TL_RAPID_TIME

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ST_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Submit Time Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: TL_ADM_NAME_VW
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: TL_ADM_EERCD_VW
4	DUR	Date(10)	DATE NOT NULL	Date Under Report associates time being reported, scheduled or paid, to a specific date.
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
6	PUNCH_TIME	Time(15)	TIMESTAMP	punch time
7	PUNCH_DTTM	DateTime(26)	TIMESTAMP	Date and time when the punch occurred.
8	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
9	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer Prompt Table: SCH_PUNCH4_VW
10	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
11	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	TASK_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Profile ID
14	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup
15	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
16	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
17	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
18	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
19	BILLABLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Billable Indicator N=No Y=Yes Default Value: N
20	RULE_ELEMENT_1	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 1
21	RULE_ELEMENT_2	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 2
22	RULE_ELEMENT_3	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 3
23	RULE_ELEMENT_4	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 4
24	RULE_ELEMENT_5	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 5
25	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate.
26	SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Regular Shift 1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating
27	OVERRIDE_RSN_CD	Character(5)	VARCHAR2(5) NOT NULL	Override Reason Code
28	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
29	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
30	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
31	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
32	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
33	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
34	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
35	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
36	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
37	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
38	CUSTOMER	Character(10)	VARCHAR2(10) NOT NULL	Customer
39	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
40	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Business Unit
41	BUSINESS_UNIT_PF	Character(5)	VARCHAR2(5) NOT NULL	Perf Meas Business Unit
42	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
43	SETID_ACTIVITY	Character(5)	VARCHAR2(5) NOT NULL	Activity Set ID
44	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
45	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Type
46	SETID_RESOURCE	Character(5)	VARCHAR2(5) NOT NULL	Resource Set ID
47	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Category
48	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Sub Category
49	TASK	Character(5)	VARCHAR2(5) NOT NULL	Task
50	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1
51	USER_FIELD_2	Character(10)	VARCHAR2(10) NOT NULL	User Field 2
52	USER_FIELD_3	Character(15)	VARCHAR2(15) NOT NULL	User Field 3
53	USER_FIELD_4	Character(20)	VARCHAR2(20) NOT NULL	User Field 4
54	USER_FIELD_5	Character(20)	VARCHAR2(20) NOT NULL	User Field 5
55	TL_COMMENTS	Character(254)	VARCHAR2(254) NOT NULL	Comments