FILENAME: D9530F14 MASTER
DESCRIPTION: FRSV3.0 GENERAL LEDGER FOCUS MASTER
FIELDNAME ALIAS FORMAT DESCRIPTION FIELDTYPE
FG003_FGRT FISCAL_YR
A2
FISCAL YEAR
FG004_FGRT CAMPUS_CODE
A2
CAMPUS CODE
FG005_FGRT ACCOUNT_NUM
A6
GL ACCOUNT NUMBER
I
STATECODE
A16
STATECODE
I
FG18B UC_OLD_FUND
A4
FUND
FG18C UC_OLD_SID A3 SID
FG068 ACCOUNT_PURPOSE
A2
FUNCTION
FRSDEPT UNIVDEPT
A7
 
FG054 DEPARTMENT A5 DEPARTMENT
FG056 SUB_DEPARTMENT
A2
SUB DEPARTMENT
FG048 EXECUTIVE_LEVEL
A2
EXECUTIVE LEVEL
FG050 DIVISION_GL
A2
DIVISION, GL
FG052 SCHOOL
A2
SCHOOL
FG066 FUND_GROUP
A2
FUND GROUP
FG072 SECURITY_CODE
A6
SECURITY CODE
FG042 ACCOUNT_DESC
A20
ACCOUNT DESCRIPTION
FG018M UC_EQUIP_OWNER
A1
EQUIPMENT OWNERSHIP
FG027 DELETE_FLAG
A1
DELETE FLAG
FG028 FREEZE_FLAG
A1
FREEZE FLAG
FG029 REVEIW_FLAG
A1
REVIEW FLAG
FG041 SL_CNTR
I9

SL, CNTR

FG043 RESPONSIBLE_PER
A20
RESPONSIBLE PERSON
FG044
ADDR
A20
BLDG, ROOM, LOCATION
FG045 YR_END_PROC
A1
YEAR END PROCESSING
FG046 REPORT_DISTR
A5
U-BOX

FG067

PAYROLL_ID

A6

PAYROLL_ID

FG070
RECLASSIFICATION A1 RECLASSIFICATION
FG074
LAST_CHG_ID A6 LAST, CHG, ID
FG076
CREATE_DT YYMD,DATE CREATE, DT
FG078
LAST_ATTR_CHG_DT YYTD,DATE LAST, ATTR,CHG,DT
FG09A UC_OLD_FRS_GL_ACCT A6 UC,OLD,FRS,GL,ACCT
FG09B
UC_MEMO_BANK_ACCT A2 UC, MEMO,BANK,ACCT
FG09C UC_NEW_FRS_ACCT

A6

UC,NEW, FRS,ACCT
FG09D UC_ASSGND_TO_CODE A3 UC,ASSGND TO CODE
FG09E UC_CONTACT_PHONE A10 UC, CONTACT, PHONE
FG09F UC_ACADEMIC_DEPT A5 UC,ACADEMIC, DEPT
FG09G UC_ACADEMIC_SCHOOL A2 UC,ACADEMIC, SCHOOL

FG127

DELETE_FLAG

A1

DELETE FLAG

FG128

FREEZE_FLAG

A1

FREEZE FLAG

FG129

REVIEW_FLAG

A1

REVIEW FLAG

FG142 LONG_DESC_A A40 LONG DESC A
FG144 LONG_DESC_B A40 LONG DESC B
FG146 OLD_ACCOUNT_NUM A15 OLD ACCOUNT NUM
FG148
PO_AUTH_PERS_1 A9 PO,AUTH,PERS,1
FG14A
UC_CORE_CT_CODE A10 UC, CORE, CT, CODE
FG14B
UC_PI_EMAIL_CODE A4 UC, PI, EMAIL, CODE
FG150
PO_AUTH_PERS_2 A9 PO,AUTH,PERS,2
FG152
PO_AUTH_PERS_3 A9 PO, AUTH,PERS,3
FG18F UC_FRNG_BEN_EXMPT A1 UC,FRNG BEN EXMPT
FG18J UC_SPEC_ACCT_IND A1 UC, SPEC ACCT IND

FG327

DELETE_FLAG

A1

DELETE FLAG

 

FG328

FREEZE_FLAG

A1

FREEZE FLAG

 

FG329

REVIEW_FLAG

A1

REVIEW FLAG

FG342 BLDG_NUM A5 BLDG NUM
FG344 BLDG_SQUARE_FT A6 BLDG,SQUARE FT
FG346 DT_IN_SERVICE YYMD,DATE   DT, IN SERVICE
FG348 DT_OF_RENOVATION YYMD.DATE  DT, OF RENOVATION
FG350 BLDG_ORIG_COST A9 BLDG, ORIG COST
FG352 AGENCY A7 AGENCY
FG38A UC_SPONSOR_NAME A50 UC, SPONSOR, NAME
FG39A UC_TOTAL_DIR_COST A12 UC, TOTAL, DIRECT, COST
FG39B UC_NONEXCHANGE A2 UC, NONEXCHANGE
FG227 DELETE_FLAG A1 DELETE FLAG
FG228 FREEZE_FLAG A1 FREEZE FLAG
FG229 REVIEW_FLAG A1 REVIEW_FLAG
FG242 TYPE_OF_FUNDING A2 LETTER OF CREDIT, INDICATOR
FG244 TYPE_OF_RESEARCH A2 TYPE OF RESEARCH
FG246 GRANT_CNTRCT_IND A1 GRANTS,DEPT,INDICATOR
FG248 RESEARCH_PURPOSE A2 RESEARCH,FND,BUDGET,TYPE
FG250 DESIGNATION A1 DESIGNATION
FG251 PROJ_YR A4 PI,COST,SHARE
FG252 FIELD_OF_SCIENCE A1 FIELD OF SCIENCE
FG254 STATUS_GL A1 STATUS, GL
FG256 PRINCIPAL_INVESTIG A4 PRINCIPAL,INVESTIG
FG258 SPONSOR A4 SPONSOR
FG260 SPONSOR_AWARD_NUM   A4 SPONSOR,AWARD,NUM
FG262 FED_OR_STATE_ID A12 FED,OR,STATE,ID
FG264 PROPOSAL_NUM A10 PROPOSAL NUM
FG268 OVERHEAD_BASE A1 OVERHEAD BASE
FG26A UC_TOTAL_IND_COST A12 UC, TOTAL, INDIRECT, COST
FG270 OVERHEAD_RATE A4 OVERHEAD RATE
FG272 REPORTING_FREQ A1 REPORTING,FREQ
FG274 START_DT YYMD  START DT
FG276 END_DT YYMD END, DT
FG278 TECH_REPORT_DT   YYMD TECH,REPORT,DT
FG280 FISCAL_REPORT_DT  YYMD FISCAL,REPORT DT
FG282 INVEN_REPORT_DT YYMD INVEN,REPORT,DT
FG284 RENEWAL_REPORT_DT  YYMD RENEWAL,REPORT,DT
FG29C UC_SPONS_ID_NUM A20 UC,SPONS,ID,NUM
FG29E UC_FED_CAT_NUM A8 UC,FED,CAT,NUM
FG29G UC_CONTING_POOL A9 UC,CONTING, POOL
FG29J UC_COST_SHARE A12 UC, COST, SHARE
FG29L UC_COMMIT_END_DATE    YYMD   UC,COMMIT,END DATE

FG903_FGDL

FISCAL_YR

A2

FISCAL YEAR

FG904_FGDL

CAMPUS_CODE

A2

CAMPUS CODE

FRSACCOUNT A10 ACCOUNT NUMBER
I

FG905_FGDL

ACCOUNT_NUM

A6

ACCOUNT NUMBER

 

FG914_FGDL SUBCODE A4 SUBCODE
FG927 DELETE_FLAG A1 DELETE FLAG
FG928 FREEZE_FLAG A1 FREEZE FLAG
FG929 REVIEW_FLAG A1 REVIEW FLAG
FG942 ACTV_CNTR I9 ACTV, CNTR
FG944 DOLLAR_DESC A20 DOLLAR, DESC
FG946 BEGIN_BAL D14.2M BEGIN BAL
FG948 CM_ACTUAL D14.2M CM, ACTUAL
FG950 CURR_BAL D14.2M CURR BAL
FG952 PRIOR_CM_ACTUAL D14.2M PRIOR CM ACTUAL
FG954 PRIOR_YTD_ACTUAL     D14.2M PRIOR YTD ACTUAL
FG956 TC_080_AMT D14.2M TC,080,AMT
FG958 TC_081_AMT D14.2M TC,081,AMT
FG960 TC_082_AMT D14.2M TC,082,AMT
FG962 TC_083_AMT D14.2M TC,083,AMT
FG998 DT_OF_LAST_ACTV   YYMD  DT OF LAST ACTV
FG964 STATE_OBJ_CODE     A6 STATE, OBJ, CODE

508 UsableNet Approved (v. 1.2.1)