GP_CAL_RUN_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	CAL_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Calendar Sequence Number
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GP_CAL_PYGRP_VW
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id Prompt Table: %GP_EDIT_FLD1
6	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
7	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
8	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
9	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
10	PRD_END_DT	Date(10)	DATE	Pay Period End Date
11	PYMT_DT	Date(10)	DATE	Payment Date
12	TRGT_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar to which retro deltas are targeted or forwarded
13	PIN_PRC_NUM	Number(8,0)	INTEGER NOT NULL	Process Element
14	TL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Time & Labor Period ID
15	TL_PRD_BGN_DT	Date(10)	DATE	Period Begin Date
16	TL_PRD_END_DT	Date(10)	DATE	Period End Date
17	PROCESS_RETRO_IND	Character(1)	VARCHAR2(1) NOT NULL	Process Retro Indicator
18	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
19	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.
20	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
21	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: GP_CAL_RUN.COUNTRY
22	CAL_FINAL_TS	DateTime(26)	TIMESTAMP	Calendar Finalized Timestamp
23	CAL_IDNT_TS	DateTime(26)	TIMESTAMP	Calendar Identify Timestamp
24	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1