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

 

508 UsableNet Approved (v. 1.2.1)