EX_TIME_DTL_H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
4	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number Default Value: 1
5	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
6	EX_LINE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report) ADJ=Adjusted APR=Approved APY=Approved for Payment CLS=Closed DEN=Denied DNA=Denied by Approver DNC=Denied DNU=Denied by Auditor ESC=Escheated Payment HDA=Hold by Approver HDU=Hold by Auditor HLD=Hold MFS=Marked For Submit OPN=Open PAR=Approvals in Process PD=Paid PND=Pending PRO=In Process RAP=Approved STG=Staged SUB=Submitted XML=Submitted, Pending Validation Default Value: PND
7	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: EX_TIME_HDR.BUSINESS_UNIT_GL
8	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
9	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
10	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: LOCAL_TAX_VW
11	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code Prompt Table: TL_TRC_TBL
12	BILLING_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Billing Action B=Billable I=Internal P=Personal U=Nonbillable Default Value: EX_TIME_HDR.BILLING_ACTION
13	BI_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Billing Distribution Status D=Distributed I=Ignore N=Not Distributed P=Priced U=Unbillable/Non-billable W=Billing Worksheet Default Value: N
14	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: %EDIT_OPER_UNIT
15	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: %EDIT_PRODUCT
16	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: %EDIT_FUND_CODE
17	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: %EDIT_CLASS_FLD
18	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: %EDIT_PROG_CODE
19	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: %EDIT_BUD_REF
20	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
21	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
22	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
23	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: %EDIT_CHARTFLD1
24	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: %EDIT_CHARTFLD2
25	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: %EDIT_CHARTFLD3
26	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
27	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
28	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
29	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
30	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
31	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
32	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
33	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
34	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: %EDIT_DEPT
35	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
36	COMMENTS	Long Character	CLOB	Comment
37	RESOURCE_ETC	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Estimate to Complete
38	CHANGE_REQ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Change Request Flag Y/N Table Edit Default Value: N
39	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order Prompt Table: SP_BU_WM_NONVW
40	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Prompt Table: %EDIT_WO_ID
41	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number Prompt Table: %EDIT_WO_TASK
42	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Management Resource Types 1=Labor 2=Tools 3=Material
43	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No. Prompt Table: %EDIT_RES_LINE
44	APPROVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver Oprid
45	APPROVER_ACTN_DT	Date(10)	DATE	The Date on which the approver takes necessary action
46	APPROVER_ADD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	New Approver Add Flag
47	ISCHANGED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Record has been changed
48	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
49	POST_STATUS_EX	Character(1)	VARCHAR2(1) NOT NULL	Expenses Post Status C=Closed M=Marked for Unpost N=Not Applied O=Unpost In Process P=Posted S=Close In Process U=Unposted
50	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
51	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.