GM_TEC_LN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_DT	Date(10)	DATE	Run Date
2	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
3	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
7	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
8	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
11	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
12	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
13	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
14	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
15	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
16	MONETARY_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Monetary Amount
17	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Statistic Amount
18	BEGIN_DT	Date(10)	DATE	Begin Date
19	END_DT	Date(10)	DATE	end date
20	REG_HRS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Regular Hours
21	OT_HRS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Overtime Hours
22	TOT_HRS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Hours
23	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Journal Line Reference
24	LINE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Journal Line Description
25	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
26	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
27	ACCOUNTING_DT	Date(10)	DATE	Accounting Date
28	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
29	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code