GPNZ_NRP_AB1_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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	BGN_DT	Date(10)	DATE	Begin Date
5	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
6	END_DT	Date(10)	DATE	end date
7	CAL_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Calendar Sequence Number
8	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
9	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
10	GPNZ_ADV_FROM_DT	Date(10)	DATE	This is the start date of the period that is to be advanced within a Calendar Period.
11	GPNZ_ADV_TO_DT	Date(10)	DATE	This is the end date of the period that is to be advanced within a Calendar Period.
12	GPNZ_ORIG_RUNID	Character(18)	VARCHAR2(18) NOT NULL	When an absence is to be paid in advance, this identifies the Calendar Group in which a Calendar would normally have been included.
13	GPNZ_SKP_FROM_DT	Date(10)	DATE	This is the start date of the period that is to be skipped (not paid) within a Calendar Period.
14	GPNZ_SKP_TO_DT	Date(10)	DATE	This is the end date of the period that is to be skipped (not paid) within a Calendar Period.
15	GPNZ_ORIG_PYMTDT	Date(10)	DATE	This is the Payment Date that the Calendar would normally paid on if it were not paid in advance.
16	GPNZ_ORIG_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Original Calendar Period ID. Used in Australian Absence Advance to recors the Period in which the payment was originally die to be paid.
17	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
18	GPNZ_ADV_SPLIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether the calendar is being split up or not. P=Part of Period Advanced S=Split Period, both advanced W=Whole Period Advanced