GP_NRP_CRDTL_AD

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