FTRATTV_COAS_CODE NOT NULL VARCHAR2(1)
FTRATTV_ATTT_CODE NOT NULL VARCHAR2(8)
FTRATTV_CODE NOT NULL VARCHAR2(8)
FTRATTV_DESC NOT NULL VARCHAR2(50)
FTRATTV_ACTIVITY_DATE NOT NULL DATE Value table FTMATTV
FTRATTV_USER_ID NOT NULL VARCHAR2(30)
FTRATTV_BEGIN_DATE NOT NULL DATE
FTRATTV_END_DATE DATE
FTRATTV_VALID_FUND_IND VARCHAR2(1)
FTRATTV_VALID_ORGN_IND VARCHAR2(1)
FTRATTV_VALID_ACCT_IND VARCHAR2(1)
FTRATTV_VALID_PROG_IND VARCHAR2(1)
FTRATTV_VALID_ACTV_IND VARCHAR2(1)
FTRATTV_VALID_LOCN_IND VARCHAR2(1)
FTRATTV_VALID_ALL_IND VARCHAR2(1)
FTRFTYA_COAS_CODE NOT NULL VARCHAR2(1)
FTRFTYA_FTYP_CODE NOT NULL VARCHAR2(2)
FTRFTYA_ATTT_CODE NOT NULL VARCHAR2(8) Ftypes for FTMFATA
FTRFTYA_ACTIVITY_DATE NOT NULL DATE
FTRFTYA_USER_ID NOT NULL VARCHAR2(30)
FTRFTYA_ATTS_CODE VARCHAR2(8)
FTRFTYA_ATTV_CODE VARCHAR2(8)
FTRATYA_COAS_CODE NOT NULL VARCHAR2(1)
FTRATYA_ATYP_CODE NOT NULL VARCHAR2(2)
FTRATYA_ATTT_CODE NOT NULL VARCHAR2(8) Atypes for FTMFATA
FTRATYA_ACTIVITY_DATE NOT NULL DATE
FTRATYA_USER_ID NOT NULL VARCHAR2(30)
FTRATYA_ATTS_CODE VARCHAR2(8)
FTRATYA_ATTV_CODE VARCHAR2(8)
FTRACTA_COAS_CODE NOT NULL VARCHAR2(1)
FTRACTA_ACCT_CODE NOT NULL VARCHAR2(6)
FTRACTA_ATTT_CODE NOT NULL VARCHAR2(8) Accounts for FTMFATA
FTRACTA_ACTIVITY_DATE NOT NULL DATE
FTRACTA_USER_ID NOT NULL VARCHAR2(30)
FTRACTA_ATTS_CODE VARCHAR2(8)
FTRACTA_ATTV_CODE VARCHAR2(8)
FTRPRGA_COAS_CODE NOT NULL VARCHAR2(1)
FTRPRGA_PROG_CODE NOT NULL VARCHAR2(6)
FTRPRGA_ATTT_CODE NOT NULL VARCHAR2(8)
FTRPRGA_ACTIVITY_DATE NOT NULL DATE Programs for FTMFATA
FTRPRGA_USER_ID NOT NULL VARCHAR2(30)
FTRPRGA_ATTS_CODE VARCHAR2(8)
FTRPRGA_ATTV_CODE VARCHAR2(8)
FTRATTV - Attribute Value table
All fields in gray are required
FTRATTV_COAS_CODE FTRATTV_ATTT_CODE FTRATTV_CODE FTRATTV_DESC FTRATTV_ACTIVITY_DATE FTRATTV_USER_ID FTRATTV_BEGIN_DATE
M G5BAA1CA 1010CURA Cash and cash equivalents 7/1/2005 7/1/2005
M G5BAA1CA 1020CURA Short-term investments 7/1/2005 7/1/2005
M G5BAA1CA 1030CURA Accounts, notes, and grants receivable (net) 7/1/2005 7/1/2005
M G5BAA1CA 1035CURA Pledges receivable (net) 7/1/2005 7/1/2005
M G5BAA1CA 1040CURA Inventories 7/1/2005 7/1/2005
M G5BAA1CA 1050CURA Prepaid expenses and deferred charges 7/1/2005 7/1/2005
M G5BAA1CA 1060CURA Accrued interest receivable 7/1/2005 7/1/2005
M G5BAA1CA 1070CURA Other assets 7/1/2005 7/1/2005
M G5BAA2NA 2010NCRA Cash and cash equivalents 7/1/2005 7/1/2005
M G5BAA2NA 2020NCRA Investments 7/1/2005 7/1/2005
M G5BAA2NA 2030NCRA Accounts, notes, and grants receivable (net) 7/1/2005 7/1/2005
M G5BAA2NA 2040NCRA Pledges receivable (net) 7/1/2005 7/1/2005
M G5BAA2NA 2050NCRA Deposit with Trustees 7/1/2005 7/1/2005
M G5BAA2NA 2060NCRA Capital assets (net) 7/1/2005 7/1/2005
M G5BAA2NA 2070NCRA Other assets 7/1/2005 7/1/2005
M G5BAA3CL 3010CLIB Accounts payable 7/1/2005 7/1/2005
M G5BAA3CL 3015CLIB Accrued liabilities 7/1/2005 7/1/2005
M G5BAA3CL 3020CLIB Due to grantors 7/1/2005 7/1/2005
M G5BAA3CL 3030CLIB Student deposits 7/1/2005 7/1/2005
M G5BAA3CL 3040CLIB Deferred revenue 7/1/2005 7/1/2005
M G5BAA3CL 3050CLIB Compensated absences 7/1/2005 7/1/2005
M G5BAA3CL 3060CLIB Accrued interest payable 7/1/2005 7/1/2005
M G5BAA3CL 3070CLIB Long-term liabilities, current portion 7/1/2005 7/1/2005
M G5BAA3CL 3080CLIB Deposits held in custody for others 7/1/2005 7/1/2005
M G5BAA3CL 3090CLIB Other liabilities 7/1/2005 7/1/2005
M G5BAA4NL 4005NCLB Accrued liabilities 7/1/2005 7/1/2005
M G5BAA4NL 4010NCLB Deferred revenue 7/1/2005 7/1/2005
M G5BAA4NL 4020NCLB Compensated absences 7/1/2005 7/1/2005
M G5BAA4NL 4030NCLB Long-term liabilities 7/1/2005 7/1/2005
M G5BAA4NL 4040NCLB Due to grantors 7/1/2005 7/1/2005
M G5BAA4NL 4050NCLB Other liabilities 7/1/2005 7/1/2005
M G5BAA9EX 9999EXCL Exclude 7/1/2005 7/1/2005
M G5BAFUND 1010PI Primary Institution 7/1/2005 7/1/2005
M G5BAFUND 1020CU Component Unit 7/1/2005 7/1/2005
M G5BAFUND 9999EXCL Exclude 7/1/2005 7/1/2005
M G5BAN1NA 1010NA Invested in capital assets, net of related debt 7/1/2005 7/1/2005
M G5BAN1NA 1020NA Restricted - nonexpendable scholarships 7/1/2005 7/1/2005
M G5BAN1NA 1025NA Restricted - nonexpendable research 7/1/2005 7/1/2005
M G5BAN1NA 1030NA Restricted - nonexpendable instructional depts 7/1/2005 7/1/2005
M G5BAN1NA 1035NA Restricted - nonexpendable other 7/1/2005 7/1/2005
M G5BAN1NA 1040NA Restricted - expendable scholarships 7/1/2005 7/1/2005
M G5BAN1NA 1045NA Restricted - expendable research 7/1/2005 7/1/2005
M G5BAN1NA 1050NA Restricted - expendable instructional depts 7/1/2005 7/1/2005
M G5BAN1NA 1055NA Restricted - expendable loans 7/1/2005 7/1/2005
M G5BAN1NA 1060NA Restricted - expendable capital projects 7/1/2005 7/1/2005
M G5BAN1NA 1065NA Restricted - expendable debt service 7/1/2005 7/1/2005
M G5BAN1NA 1070NA Restricted - expendable other 7/1/2005 7/1/2005
M G5BAN1NA 1090NA Unrestricted 7/1/2005 7/1/2005
M G5BAN93X 9999EXCL Exclude 7/1/2005 7/1/2005
M G5BAPROG 1010CUR Instruction 7/1/2005 7/1/2005
FTRATTV - Attribute Value table
All fields in gray are required
FTRATTV_COAS_CODE FTRATTV_ATTT_CODE FTRATTV_CODE FTRATTV_DESC FTRATTV_ACTIVITY_DATE FTRATTV_USER_ID FTRATTV_BEGIN_DATE
M G5BAPROG 1020CUR Research 7/1/2005 7/1/2005
M G5BAPROG 1030CUR Public service 7/1/2005 7/1/2005
M G5BAPROG 1040CUR Academic support 7/1/2005 7/1/2005
M G5BAPROG 1050CUR Student services 7/1/2005 7/1/2005
M G5BAPROG 1060CUR Institutional support 7/1/2005 7/1/2005
M G5BAPROG 1070CUR Operation and maintenance of plant 7/1/2005 7/1/2005
M G5BAPROG 1080CUR Scholarships and fellowships 7/1/2005 7/1/2005
M G5BAPROG 1085CUR depreciation 7/1/2005 7/1/2005
M G5BAPROG 1090CUR Auxiliary enterprises 7/1/2005 7/1/2005
M G5BAPROG 9999EXCL Exclude 7/1/2005 7/1/2005
M G5BAR1OR 1010OPRV Student tuition and fees 7/1/2005 7/1/2005
M G5BAR1OR 1020OPRV Gifts and contributions 7/1/2005 7/1/2005
M G5BAR1OR 1030OPRV Endowment Income (per spending plan) 7/1/2005 7/1/2005
M G5BAR1OR 1040OPRV Governmental grants and contracts 7/1/2005 7/1/2005
M G5BAR1OR 1050OPRV Non-governmental grants and contracts 7/1/2005 7/1/2005
M G5BAR1OR 1060OPRV Sales and services of educational departments 7/1/2005 7/1/2005
M G5BAR1OR 1070OPRV Patient Charges 7/1/2005 7/1/2005
M G5BAR1OR 1080OPRV Residential life 7/1/2005 7/1/2005
M G5BAR1OR 1082OPRV Bookstore 7/1/2005 7/1/2005
M G5BAR1OR 1084OPRV Food service 7/1/2005 7/1/2005
M G5BAR1OR 1086OPRV Wellness facility 7/1/2005 7/1/2005
M G5BAR1OR 1089OPRV Other auxiliaries 7/1/2005 7/1/2005
M G5BAR1OR 1090OPRV Interest earned on loans to students 7/1/2005 7/1/2005
M G5BAR1OR 1095OPRV Other operating revenues 7/1/2005 7/1/2005
M G5BAR2OE 2010OPEX Salaries and wages 7/1/2005 7/1/2005
M G5BAR2OE 2020OPEX Benefits 7/1/2005 7/1/2005
M G5BAR2OE 2030OPEX Utilities, supplies, and other services 7/1/2005 7/1/2005
M G5BAR2OE 2040OPEX Scholarships and fellowships 7/1/2005 7/1/2005
M G5BAR2OE 2050OPEX Depreciation expense 7/1/2005 7/1/2005
M G5BAR2OE 2060OPEX Payments to or on behalf of institution 7/1/2005 7/1/2005
M G5BAR2OE 9999EXCL Exclude 7/1/2005 7/1/2005
M G5BAR3NO 3010NOPR State appropriations 7/1/2005 7/1/2005
M G5BAR3NO 3020NOPR Gifts 7/1/2005 7/1/2005
M G5BAR3NO 3030NOPR Grants and contracts 7/1/2005 7/1/2005
M G5BAR3NO 3040NOPR Investment income 7/1/2005 7/1/2005
M G5BAR3NO 3050NOPR Interest on capital asset-related debt 7/1/2005 7/1/2005
M G5BAR3NO 3060NOPR Bond issuance costs 7/1/2005 7/1/2005
M G5BAR3NO 3070NOPR Payments to ETSU or ETSU Foundation 7/1/2005 7/1/2005
M G5BAR3NO 3080NOPR Other non-operating revenues/(expenses) 7/1/2005 7/1/2005
M G5BAR4OT 4010OTCH Capital appropriations 7/1/2005 7/1/2005
M G5BAR4OT 4020OTCH Capital grants and gifts 7/1/2005 7/1/2005
M G5BAR4OT 4030OTCH Additions to permanent endowments 7/1/2005 7/1/2005
M G5BAR4OT 4040OTCH Other capital 7/1/2005 7/1/2005
M G5BAR9EX 9999EXCL Exclude 7/1/2005 7/1/2005
FTMFATA - FOAPAL Attribute Association Form
This is the table for mapping fund types. Gray fields are required.
FTRFTYA_COAS_CODE FTRFTYA_FTYP_CODE FTRFTYA_ATTT_CODE FTRFTYA_ACTIVITY_DATE FTRFTYA_USER_ID FTRFTYA_ATTS_CODE FTRFTYA_ATTV_CODE
11 G5BAFUND 7/1/2005 1010PI
21 G5BAFUND 7/1/2005 1010PI
31 G5BAFUND 7/1/2005 1010PI
41 G5BAFUND 7/1/2005 1010PI
61 G5BAFUND 7/1/2005 1010PI
81 G5BAFUND 7/1/2005 1010PI
91 G5BAFUND 7/1/2005 1010PI
93 G5BAFUND 7/1/2005 1010PI
95 G5BAFUND 7/1/2005 1010PI
97 G5BAFUND 7/1/2005 1010PI
99 G5BAFUND 7/1/2005 9999EXCL
FTMFATA - FOAPAL Attribute Association Form
This is the table for mapping Account types. Gray fields are required.
FTRATYA_COAS_CODE FTRATYA_ATYP_CODE FTRATYA_ATTT_CODE FTRATYA_ACTIVITY_DATE FTRATYA_USER_ID FTRATYA_ATTS_CODE FTRATYA_ATTV_CODE
51 G5BAR1OR 7/1/2005 1010OPRV
53 G5BAR1OR 7/1/2005 1040OPRV
54 G5BAR1OR 7/1/2005 1040OPRV
55 G5BAR1OR 7/1/2005 1040OPRV
56 G5BAR1OR 7/1/2005 1050OPRV
57 G5BAR3NO 7/1/2005 3020NOPR
58 G5BAR1OR 7/1/2005 1060OPRV
59 G5BAR1OR 7/1/2005 1095OPRV
5A G5BAR3NO 7/1/2005 3040NOPR
5D G5BAR3NO 7/1/2005 3030NOPR
5E G5BAR4OT 7/1/2005 4020OTCH
5F G5BAR4OT 7/1/2005 4030OTCH
5G G5BAR1OR 7/1/2005 1020OPRV
5H G5BAR3NO 7/1/2005 3080NOPR
5J G5BAR4OT 7/1/2005 4040OTCH
61 G5BAR2OE 7/1/2005 2010OPEX
62 G5BAR2OE 7/1/2005 2020OPEX
71 G5BAR2OE 7/1/2005 2030OPEX
74 G5BAR2OE 7/1/2005 2030OPEX
78 G5BAR2OE 7/1/2005 9999EXCL
79 G5BAR2OE 7/1/2005 2040OPEX
7A G5BAR2OE 7/1/2005 2050OPEX
7B G5BAR1OR 7/1/2005 1040OPRV
81 G5BAR2OE 7/1/2005 9999EXCL
94 G5BAN1NA 7/1/2005 1090NA
96 G5BAN1NA 7/1/2005 1090NA
31 G5BAN1NA 7/1/2005 1090NA
FTMFATA - FOAPAL Attribute Association Form
This is the table for mapping Account Codes. Gray fields are required.
FTRACTA_COAS_CODE FTRACTA_ACCT_CODE FTRACTA_ATTT_CODE FTRACTA_ACTIVITY_DATE FTRACTA_USER_ID FTRACTA_ATTS_CODE FTRACTA_ATTV_CODE
110 G5BAA1CA 7/1/2005 1010CURA
120 G5BAA1CA 7/1/2005 1020CURA
130 G5BAA1CA 7/1/2005 1030CURA
140 G5BAA1CA 7/1/2005 1030CURA
150 G5BAA1CA 7/1/2005 1040CURA
160 G5BAA1CA 7/1/2005 1050CURA
170 G5BAA1CA 7/1/2005 1035CURA
180 G5BAA1CA 7/1/2005 1070CURA
190 G5BAA1CA 7/1/2005 1060CURA
11A G5BAA2NA 7/1/2005 2010NCRA
12A G5BAA2NA 7/1/2005 2020NCRA
13A G5BAA2NA 7/1/2005 2030NCRA
17A G5BAA2NA 7/1/2005 2040NCRA
11B G5BAA2NA 7/1/2005 2050NCRA
18A G5BAA2NA 7/1/2005 2070NCRA
171 G5BAA2NA 7/1/2005 2060NCRA
210 G5BAA3CL 7/1/2005 3010CLIB
220 G5BAA3CL 7/1/2005 3015CLIB
270 G5BAA3CL 7/1/2005 3020CLIB
250 G5BAA3CL 7/1/2005 3030CLIB
280 G5BAA3CL 7/1/2005 3040CLIB
290 G5BAA3CL 7/1/2005 3050CLIB
2A0 G5BAA3CL 7/1/2005 3060CLIB
26A G5BAA3CL 7/1/2005 3070CLIB
2C0 G5BAA3CL 7/1/2005 3080CLIB
2B0 G5BAA3CL 7/1/2005 3090CLIB
22A G5BAA4NL 7/1/2005 4005NCLB
28A G5BAA4NL 7/1/2005 4010NCLB
29A G5BAA4NL 7/1/2005 4020NCLB
260 G5BAA4NL 7/1/2005 4030NCLB
27A G5BAA4NL 7/1/2005 4040NCLB
2BA G5BAA4NL 7/1/2005 4050NCLB
400 G5BAN1NA 7/1/2005 1010NA
41100 G5BAN1NA 7/1/2005 1020NA
41200 G5BAN1NA 7/1/2005 1025NA
41250 G5BAN1NA 7/1/2005 1030NA
41300 G5BAN1NA 7/1/2005 1035NA
42100 G5BAN1NA 7/1/2005 1040NA
42200 G5BAN1NA 7/1/2005 1045NA
42300 G5BAN1NA 7/1/2005 1050NA
42400 G5BAN1NA 7/1/2005 1055NA
42500 G5BAN1NA 7/1/2005 1060NA
42600 G5BAN1NA 7/1/2005 1065NA
42700 G5BAN1NA 7/1/2005 1070NA
490 G5BAN1NA 7/1/2005 1090NA
5C3 G5BAR1OR 7/1/2005 1080OPRV
5C1 G5BAR1OR 7/1/2005 1082OPRV
5C2 G5BAR1OR 7/1/2005 1084OPRV
5C6 G5BAR1OR 7/1/2005 1086OPRV
5C4 G5BAR1OR 7/1/2005 1089OPRV
5C5 G5BAR1OR 7/1/2005 1089OPRV
5C7 G5BAR1OR 7/1/2005 1089OPRV
FTMFATA - FOAPAL Attribute Association Form
This is the table for mapping Account Codes. Gray fields are required.
FTRACTA_COAS_CODE FTRACTA_ACCT_CODE FTRACTA_ATTT_CODE FTRACTA_ACTIVITY_DATE FTRACTA_USER_ID FTRACTA_ATTS_CODE FTRACTA_ATTV_CODE
5C8 G5BAR1OR 7/1/2005 1089OPRV
5C9 G5BAR1OR 7/1/2005 1089OPRV
7C10 G5BAR3NO 7/1/2005 3050NOPR
7C20 G5BAR3NO 7/1/2005 3060NOPR
7C30 G5BAR4OT 7/1/2005 4040OTCH
5200A G5BAR3NO 7/1/2005 3010NOPR
5200B G5BAR4OT 7/1/2005 4010OTCH
52000 G5BAR3NO 7/1/2005 3010NOPR State appropriations
52010 G5BAR4OT 7/1/2005 4010OTCH Capital appropriations
7D0 G5BAR2OE 7/1/2005 2030OPEX Loan Fund Additions/Deductions
58900 G5BAR1OR 7/1/2005 1040OPRV Loan Fund Additions/Deductions
58930 G5BAR1OR 7/1/2005 1090OPRV Loan Fund Additions/Deductions
58925 G5BAR1OR 7/1/2005 1090OPRV Loan Fund Additions/Deductions
58915 G5BAR1OR 7/1/2005 1095OPRV Loan Fund Additions/Deductions
58920 G5BAR1OR 7/1/2005 1095OPRV Loan Fund Additions/Deductions
79985 G5BAR1OR 7/1/2005 1095OPRV Loan Fund Additions/Deductions
79986 G5BAR1OR 7/1/2005 1095OPRV Loan Fund Additions/Deductions
79880 G5BAR3NO 7/1/2005 3050NOPR Loan Fund Additions/Deductions
79900 G5BAR3NO 7/1/2005 3060NOPR Loan Fund Additions/Deductions
79920 G5BAR4OT 7/1/2005 4040OTCH Loan Fund Additions/Deductions
7B20 G5BAR3NO 3020NOPR Refunds to Grantors
7B30 G5BAR3NO 3020NOPR Expired Grants
FTMFATA - FOAPAL Attribute Association Form
This is the table for mapping Program Codes. Gray fields are required.
FTRPRGA_COAS_CODE FTRPRGA_PROG_CODE FTRPRGA_ATTT_CODE FTRPRGA_ACTIVITY_DATE FTRPRGA_USER_ID FTRPRGA_ATTS_CODE FTRPRGA_ATTV_CODE
20 G5BAPROG 7/1/2005 1010CUR
25 G5BAPROG 7/1/2005 1020CUR
30 G5BAPROG 7/1/2005 1030CUR
35 G5BAPROG 7/1/2005 1040CUR
40 G5BAPROG 7/1/2005 1050CUR
45 G5BAPROG 7/1/2005 1060CUR
50 G5BAPROG 7/1/2005 1070CUR
55 G5BAPROG 7/1/2005 1080CUR
60 G5BAPROG 7/1/2005 9999EXCL
70 G5BAPROG 7/1/2005 1090CUR
80 G5BAPROG 7/1/2005 1085CUR
99 G5BAPROG 7/1/2005 9999EXCL
10 G5BAPROG 7/1/2005 9999EXCL