| FILENAME: | D9530F15 MASTER |
| DESCRIPTION: | FRSV3.0 SUBSIDIARY LEDGER FOCUS MASTER |
|
| FIELDNAME | ALIAS | FORMAT | DESCRIPTION | FIELDTYPE |
|---|---|---|---|---|
| FS003_FSRT | FISCAL_YEAR |
A2
|
FISCAL YEAR | |
| FS004_FSRT | CAMPUS_CODE |
A2
|
CAMPUS CODE | |
| FS005_FSRT | ACCOUNT_NUM |
A6
|
SL ACCOUNT NUMBER |
I
|
| STATECODE |
A16
|
STATECODE |
I
|
|
| FS19B | UC_OLD_FUND |
A4
|
FUND | |
| FS19C | UC_OLD_SID |
A3
|
SID | |
| FS074 | ACCOUNT_PURPOSE | A2 | FUNCTION | |
| FRSDEPT | UNIVDEPT |
A7
|
DEPARTMENT | |
| FS054 | DEPARTMENT | A5 | DEPARTMENT | |
| FS056 | SUB_DEPARTMENT |
A2
|
SUB DEPARTMENT | |
| FS048 | EXECUTIVE_LEVEL |
A2
|
EXECUTIVE LEVEL | |
| FS050 | DIVISION_SL |
A2
|
SL DIVISION | |
| FS052 | SCHOOL |
A2
|
SCHOOL | |
| FS066 | FUND_GROUP |
A2
|
FUND GROUP | |
| FS088 | SECURITY_CODE |
A6
|
SECURITY CODE | |
| FS042 | ACCOUNT_DESC |
A20
|
ACCOUNT DESCRIPTION | |
| FS019M | UC_EQUIP_OWNER |
A1
|
EQUIPMENT OWNERSHIP | |
| FS027 | DELETE_FLAG |
A1
|
DELETE FLAG | |
| FS028 | FREEZE_FLAG |
A1
|
FREEZE FLAG | |
| FS029 | REVEIW_FLAG |
A1
|
REVIEW FLAG | |
| FS031 | SUPPRESS_BDGT_MSG |
A1
|
SUPPRESS BUDGET MSG | |
| FS032 | ABR_FLAG |
A1
|
ABR FLAG | |
| FS034 | GL_MAP_ACCOUNT |
A5
|
GL MAP ACCOUNT | |
| FS044 | RESPONSIBLE_PER |
A20
|
RESPONSIBLE PERSON | |
| FS046 | REPORT_DISTR |
A5
|
REPORT DISTRIBUTION | |
| FS058 | YR_END_PROC |
A1
|
YEAR END PROCESSING | |
|
FS060
|
ADDR
|
A20
|
BLDG, ROOM, LOCATION
|
|
|
FS062
|
REVENUE_SOURCE
|
A4
|
REVENUE SOURCE
|
|
|
FS064
|
EXPENSE_PURPOSE
|
A4
|
EXPENSE PURPOSE
|
|
|
FS068 |
PAYROLL_ID |
A6 |
EE PAYROLL ID |
|
|
FS070 |
MAJOR_FUND_SOURCE |
A2 |
MAJOR, FUND SOURCE |
|
|
FS072
|
MINOR_FUND_SOURCE | A3 | MINOR_FUND_SOURCE | |
|
FS076
|
RECLASSIFICATION | A1 | RECLASSIFICATION | |
|
FS078
|
FBM046_RESP_PERS | A6 | FB046,RESP,PERS | |
|
FS080
|
FBM046_PROGRAM | A6 | FBM046,PROGRAM | |
|
FS083
|
QTD1_END_MONTH | A2 | QTD1,END MONTH | |
|
FS084
|
QTD2_END_MONTH | A2 | QTD2,END MONTH | |
|
FS085
|
QTD3_END_MONTH | A2 | QTD3,END MONTH | |
|
FS086
|
QTD4_END_MONTH | A2 | QTD4, END MONTH | |
|
FS087
|
PROJ_FYTD_END_MO | A2 | PROJ,FYTD,END,MO | |
|
FS089
|
PO_AUTH_PERS_1 | A9 | PO,AUTH,PERS,1 | |
|
FS090
|
PO_AUTH_PERS_2 | A9 | PO,AUTH,PERS,2 | |
|
FS091
|
PO_AUTH_PERS_3 | A9 | PO, AUTH,PERS,3 | |
|
FS092
|
LAST_CHG_ID | A6 | LAST, CHG, ID | |
|
FS093
|
CREATE_DT | YYMD,DATE | CREATE, DT | |
|
FS095
|
LAST_ATTR_CHG_DT | YYTD,DATE | LAST, ATTR,CHG,DT | |
| FS09A | UC_TOTAL_ IND_COST | A12 | UC, TOTAL, INDIRECT, COST | |
| FS09B | UC_TOTAL_ DIR_COST | A2 | UC, TOTAL, DIRECT, COST | |
|
FS10A
|
UC_CONTACT_PHONE | A10 | UC,CONTACT PHONE | |
|
FS10B
|
UC_TELEPHONE_AREA | A3 | UC,TELEPHONE, AREA | |
|
FS10D
|
UC_TEL_FIRST_3 | A3 | UC,TEL,FIRST,3 | |
|
FS10E
|
UC_TEL_LAST_4 | A4 | UC,TEL,LAST,4 | |
|
FS10F
|
UC_MEMO_BANK_ACCT | A2 | UC, MEMO,BANK,ACCT | |
| FS10G | UC_NEW_FRS_ACCT | A6 | UC, NEW, FRS,ACCT | |
| FS10H | UC_ASSGND_TO_CODE | A3 | UC, ASSGND, TO, CODE | |
| FS10K | UC_OLD_SL_ACCT_NBR | A2 | UC, OLD, SL, ACCT, NBR | |
| FS10L | UC_ACADMEIC_ DEPT | A5 | UC, ACADEMIC, DEPT | |
| FS10M | UC_ACADMEIC_ SCHOOL | A2 | UC, ACADEMIC, SCHOOL | |
| FS10N | UC_NONEXCHANGE | A2 | UC, NONEXCHANGE | |
|
FS103_FSPJ |
FISCAL_YR |
A2 |
FISCAL YEAR |
|
|
FS104_FSPJ |
CAMPUS_CODE |
A2 |
CAMPUS CODE |
|
|
FS105_FSPJ |
ACCOUNT_NUM |
A6 |
SUBSIDIARY LEDGER, ACCOUNT NUMBER |
I |
|
FS127 |
DELETE_FLAG |
A1 |
DELETE FLAG |
|
|
FS128 |
FREEZE_FLAG |
A1 |
FREEZE FLAG |
|
|
FS129 |
REVIEW_FLAG |
A1 |
REVIEW FLAG |
|
| FS131 | SUPPRESS_BDGT_MSG | A1 | SUPPRESS, BDGT, MSG | |
| FS132 | ABR_FLAG | A1 | ABR,FLAG | |
| FS134 | GL_MAP_ACCOUNT | A5 | GL, MAP,ACCOUNT | |
| FS142 | LONG_DESC_A | A40 | LONG DESC A | |
| FS144 | LONG_DESC_B | A40 | LONG DESC B | |
| FS158 | BLDG_NUM | A5 | BLDG NUM | |
| FS160 | BLDG_SQUARE_FT | A6 | BLDG,SQUARE FT | |
| FS162 | DT_IN_SERVICE | YYMD,DATE | DT, IN SERVICE | |
| FS164 | DT_OF_RENOVATION | YYMD.DATE | DT, OF RENOVATION | |
| FS166 | BLDG_ORIG_COST | A9 | BLDG, ORIG COST | |
| FS168 | AGENCY | A7 | AGENCY | |
| FS174 | OLD_ACCOUNT_NUM | A15 | OLD ACCOUNT NUM | |
| FS17A | UC_CORE_CT_CODE | A10 | UC, CORE ,CT, CODE | |
| FS17B | UC_PI_EMAIL_CODE | A4 | UC, PI ,EMAIL, CODE | |
| FS19F | UC_FRNG_BEN_EXMPT | A1 | FRINGE EXEMPT ACCT | |
| FS19J | UC_SPEC_ACCT_IND | A1 | UC, SPEC ACCT IND | |
| FS19N | UC_SPONSOR_NAME | A50 | UC, SPONSOR NAME | |
| FS203_FSPJ | FISCAL_YR |
A2 |
FISCAL YR | |
| FS204_FSPJ | CAMPUS_CODE | A2 | CAMPUS CODE | |
| FS205_FSPJ | ACCOUNT_NUM | A6 | ACCOUNT NUM | |
| FS227 | DELETE_FLAG | A1 | DELETE FLAG | |
| FS228 | FREEZE_FLAG | A1 | FREEZE FLAG | |
| FS229 | REVIEW_FLAG | A1 | REVIEW FLAG | |
| FS231 | SUPPRESS_BDGT_MSG | A1 | SUPPRESS BDGT MSG | |
| FS232 | ABR_FLAG | A1 | ABR FLAG | |
| FS234 | GL_MAP_ACCOUNT | A5 | GL, MAP, ACCOUNT | |
| FS242 | TYPE_OF_FUNDING | A2 | LETTER OF CREDIT, INDICATOR | |
| FS244 | TYPE_OF_RESEARCH | A2 | TYPE OF RESEARCH | |
| FS246 | GRANT_CNTRCT_IND | A1 | GRANTS,DEPT,INDICATOR | |
| FS248 | RESEARCH_PURPOSE | A2 | RESEARCH,FND,BUDGET,TYPE | |
| FS250 | DESIGNATION | A1 | DESIGNATION | |
| FS251 | PROJ_YR | A4 | PI,COST,SHARE | |
| FS252 | FIELD_OF_SCIENCE | A1 | FIELD OF SCIENCE | |
| FS254 | STATUS_SL | A1 | STATUS, SL | |
| FS256 | PRINCIPAL_INVESTIG | A4 | PRINCIPAL,INVESTIG | |
| FS258 | SPONSOR | A4 | SPONSOR | |
| FS260 | SPONSOR_AWARD_NUM | A4 | SPONSOR,AWARD,NUM | |
| FS262 | FED_OR_STATE_ID | A12 | FED,OR,STATE,ID | |
| FS264 | PROPOSAL_NUM | A10 | PROPOSAL NUM | |
| FS268 | OVERHEAD_BASE | A1 | OVERHEAD BASE | |
| FS270 | OVERHEAD_RATE | A4 | OVERHEAD RATE | |
| FS272 | REPORTING_FREQ | A1 | REPORTING,FREQ | |
| FS274 | START_DT | YYMD,DATE | START DT | |
| FS276 | END_DT | YYMD,DATE | END, DT | |
| FS278 | TECH_REPORT_DT | YYMD,DATE | TECH,REPORT,DT | |
| FS280 | FISCAL_REPORT_DT | YYMD,DATE | FISCAL,REPORT DT | |
| FS282 | INVEN_REPORT_DT | YYMD,DATE | INVEN,REPORT,DT | |
| FS284 | RENEWAL_REPORT_DT | YYMD,DATE | RENEWAL,REPORT,DT | |
| FS29C | UC_SPONS_ID_NUM | A20 | UC,SPONS,ID,NUM | |
| FS29E | UC_FED_CAT_NUM | A8 | UC,FED,CAT,NUM | |
| FS29G | UC_CONTING_POOL | A9 | UC,CONTING, POOL | |
| FS29J | UC_COST_SHARE | A12 | UC, COST, SHARE | |
| FS29L | UC_COMMIT_END_DATE | YYMD,DATE | UC,COMMIT,END DATE | |
| FS29N | UC_PMS_DOC_NUM | A12 | UC,PMS,DOC,NUM | |
| FS903_FSDL | FISCAL_YR | A2 | FISCAL YR | |
| FS904_FSDL | CAMPUS_CODE | A2 | CAMPUS CODE | |
| FRSACCOUNT | A10 | ACCOUNT NUMBER |
I |
|
| FS905_FSDL | ACCOUNT_NUM | A6 | ACCOUNT NUM | |
| FS914_FSDL | SUBCODE | A4 | SUBCODE | |
| FS927 | DELETE_FLAG | A1 | DELETE FLAG | |
| FS928 | FREEZE_FLAG | A1 | FREEZE FLAG | |
| FS929 | REVIEW_FLAG | A1 | REVIEW FLAG | |
| FS931 | SUPPRESS_BDGT_MSG | A1 | SUPPRESS BDGT MSG | |
| FS932 | ABR_FLAG | A1 | ABR FLAG | |
| FS934 | GL_MAP_ACCOUNT | A5 | GL, MAP ACCOUNT | |
| FS942 | DOLLAR_DESC | A20 | DOLLAR, DESC | |
| FS944 | ORIG_BUDGET | D14.2M | ORIG BUDGET | |
| FS945 | ABR_BUDGET | D14.2M | ABR BUDGET | |
| FS946 | ANNUAL_BUDGET | D14.2M | ANNUAL BUDGET | |
| FS947 | PAST_BUDGET | D14.2M | PAST BUDGET | |
| FS948 | FUTURE_BUDGET | D14.2M | FUTURE BUDGET | |
| FS949 | CM_ACTUAL | D14.2M | CM ACTUAL | |
| FS960 | YTD_ACTUAL | D14.2M | YTD, ACTUAL | |
| FS962 | PTD_ACTUAL | D14.2M | PTD, ACTUAL | |
| FS963 | ENCUMBRANCES | D14.2M | ENCUMBRANCES | |
| FS964 | REQUISITIONS | D14.2M | REQUISITIONS | |
| FS965 | BUDGET_BAL_AVAIL | D14.2M | BUDGET, BAL, AVAIL | |
| FS966 | PRIOR_CM_ACTUAL | D14.2M | PRIOR CM ACTUAL | |
| FS967 | PRIOR_YTD_ACTUAL | D14.2M | PRIOR YTD ACTUAL | |
| FS968 | LAST_YR_ACTUAL | D14.2M | LAST YR ACTUAL | |
| FS970 | QTD1_ACTUAL | D14.2M | QTD1, ACTUAL | |
| FS971 | QTD2_ACTUAL | D14.2M | QTD2, ACTUAL | |
| FS972 | QTD3_ACTUAL | D14.2M | QTD3, ACTUAL | |
| FS973 | QTD4_ACTUAL | D14.2M | QTD4, ACTUAL | |
| FS974 | PROJ_FYTD_ACTUAL | D14.2M | PROJ,FYTD, ACTUAL | |
| FS975 | TC_080_AMT | D14.2M | TC,080,AMT | |
| FS976 | TC_081_AMT | D14.2M | TC,081,AMT | |
| FS977 | TC_082_AMT | D14.2M | TC,082,AMT | |
| FS978 | TC_083_AMT | D14.2M | TC,083,AMT | |
| FS979 | CM_ORIG_BUDGET | D14.2M | CM, ORIG, BUDGET | |
| FS980 | CM_REVISED_BUDGET | D14.2M | CM, REVISED, BUDGET | |
| FS981 | YTD_ORIG_BUDGET | D14.2M | YTD, ORIG, BUDGET | |
| FS982 | YTD_REVISED_BUDGET | D14.2M | YTD, REVISED BUDGET | |
| FS983 | STATE_OBJ_CODE | A6 | STATE, OBJ, CODE | |
| FS997 | DT_OF_LAST_ACTV | YYMD,DATE | DT OF LAST ACTV | |
| FS998 | MONTHLY_ACTV_CNTR | I9 | MONTHLY ACTV CNTR |
I4 |
