GP_CL_RN_DL_HST

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	CAL_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Calendar Sequence Number
5	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GP_CAL_PYGRP_VW
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id Prompt Table: %GP_EDIT_FLD1
8	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
9	CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Process Type. Identifies a run as either absence run or payroll run A=Absence Calculation B=All Calculations P=Payroll Calculation
10	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
11	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
12	PRD_END_DT	Date(10)	DATE	Pay Period End Date
13	PYMT_DT	Date(10)	DATE	Payment Date
14	TRGT_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar to which retro deltas are targeted or forwarded
15	PIN_PRC_NUM	Number(8,0)	INTEGER NOT NULL	Process Element
16	TL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Time & Labor Period ID
17	TL_PRD_BGN_DT	Date(10)	DATE	Time && Labor Period Bgn Dt
18	TL_PRD_END_DT	Date(10)	DATE	Time && Labaor Period End Dt
19	PROCESS_RETRO_IND	Character(1)	VARCHAR2(1) NOT NULL	Process Retro Indicator
20	SEL_CRIT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Selection Criteria Option 0=Payee List 1=All Active 2=Active with PI 3=Active with Retro Trigger 4=Active with PI or Rto Trigger 5=Active or has PI 6=Active or has Retro Trigger 7=Active or has PI or Rto Trgr 8=All payees with PI 9=All payees with Retro Changes A=All with PI or Retro Trigger
21	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
23	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: GP_CAL_RUN.COUNTRY
24	CAL_FINAL_TS	DateTime(26)	TIMESTAMP	Calendar Finalized Timestamp
25	CAL_IDNT_TS	DateTime(26)	TIMESTAMP	Calendar Identify Timestamp
26	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1