TL_RAPID_PTIME

#	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	PUNCH_TIME	Time(15)	TIMESTAMP NOT NULL	punch time
6	PUNCH_DTTM	DateTime(26)	TIMESTAMP	Date and time when the punch occurred.
7	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
8	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
9	TASK_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Profile ID
10	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup
11	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
12	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
13	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
14	RULE_ELEMENT_1	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 1
15	RULE_ELEMENT_2	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 2
16	RULE_ELEMENT_3	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 3
17	RULE_ELEMENT_4	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 4
18	RULE_ELEMENT_5	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 5
19	OVERRIDE_RSN_CD	Character(5)	VARCHAR2(5) NOT NULL	Override Reason Code
20	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
21	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
22	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
23	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
24	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
25	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
26	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
27	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
28	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
29	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
30	CUSTOMER	Character(10)	VARCHAR2(10) NOT NULL	Customer
31	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
32	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Business Unit
33	BUSINESS_UNIT_PF	Character(5)	VARCHAR2(5) NOT NULL	Perf Meas Business Unit
34	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
35	SETID_ACTIVITY	Character(5)	VARCHAR2(5) NOT NULL	Activity Set ID
36	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
37	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Type
38	SETID_RESOURCE	Character(5)	VARCHAR2(5) NOT NULL	Resource Set ID
39	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Category
40	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Sub Category
41	TASK	Character(5)	VARCHAR2(5) NOT NULL	Task
42	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1
43	USER_FIELD_2	Character(10)	VARCHAR2(10) NOT NULL	User Field 2
44	USER_FIELD_3	Character(15)	VARCHAR2(15) NOT NULL	User Field 3
45	USER_FIELD_4	Character(20)	VARCHAR2(20) NOT NULL	User Field 4
46	USER_FIELD_5	Character(20)	VARCHAR2(20) NOT NULL	User Field 5
47	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
48	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc., Default Value: 0
49	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
50	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
51	BILLABLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Billable Indicator N=No Y=Yes Default Value: N
52	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate.
53	TL_COMMENTS	Character(254)	VARCHAR2(254) NOT NULL	Comments