GL_INT_DT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	ITEM_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Item Type Prompt Table: ITEM_TYPE_TBL
3	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: TERM_VAL_TBL
4	SESSION_CODE	Character(3)	VARCHAR2(3) NOT NULL	Session 1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2 Prompt Table: SESSION_CODE_VW
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
7	AP_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_FS
8	AP_LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: LED_DEFN_TBL Set Control Field: AP_BUS_UNIT
9	AP_ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
10	AP_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
11	AP_PROJ_ID	Character(15)	VARCHAR2(15) NOT NULL	Project ID
12	AP_PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
13	AP_FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund
14	AP_PROG_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program
15	AP_CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
16	AP_AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
17	AP_OP_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
18	AP_ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
19	AP_BUD_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
20	AP_CF1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
21	AP_CF2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 2
22	AP_CF3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 3
23	AP_AFF_INT1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
24	AP_AFF_INT2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
25	WRITEOFF_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_FS
26	WRITEOFF_LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: LED_DEFN_TBL Set Control Field: WRITEOFF_BUS_UNIT
27	WRITEOFF_ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
28	WRITEOFF_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
29	WRITEOFF_PROJ_ID	Character(15)	VARCHAR2(15) NOT NULL	Project ID
30	WRITEOFF_PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
31	WRITEOFF_FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
32	WRITEOFF_PROG_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
33	WRITEOFF_CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
34	WRITEOFF_AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
35	WRITEOFF_OP_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Writeoff Operating Unit
36	WRITEOFF_ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Writeoff Alternate Account
37	WRITEOFF_BUD_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
38	WRITEOFF_CF1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
39	WRITEOFF_CF2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 2
40	WRITEOFF_CF3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 3
41	WRITEOFF_AFF_INT1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
42	WRITEOFF_AFF_INT2	Character(10)	VARCHAR2(10) NOT NULL	Writeoff Operating Unit Affiliate
43	EXT_WRITEOFF	Character(50)	VARCHAR2(50) NOT NULL	External Writeoff