GPNZ_NRP_AB2_VW (SQL View)	Index Back
Absence Advance details This table is a list o fthe Calendar that are to be paid in advance for an absence.

GPNZ_NRP_AB2_VW

(SQL View)

Absence Advance details

This table is a list o fthe Calendar that are to be paid in advance for an absence.

SELECT EMPLID , EMPL_RCD , BGN_DT , PIN_TAKE_NUM + 50000000 , END_DT , CAL_SEQ_NUM , GP_PAYGROUP , CAL_ID , GPNZ_ADV_FROM_DT , GPNZ_ADV_TO_DT , GPNZ_SKP_FROM_DT , GPNZ_SKP_TO_DT , GPNZ_ORIG_RUNID , GPNZ_ORIG_PYMTDT , GPNZ_ORIG_PRD_ID , CALC_TYPE , GPNZ_ADV_SPLIT_FLG FROM PS_GPNZ_ABSRET_CAL

Parent record: GP_ABSEVT_SGPAU

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 BGN_DT Date(10) DATE NOT NULL Begin Date

4 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
Prompt Table: GP_PIN_ABSTK_VW

5 END_DT Date(10) DATE NOT NULL end date

6 CAL_SEQ_NUM Number(8,0) INTEGER NOT NULL Calendar Sequence Number

7 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

8 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

9 GPNZ_ADV_FROM_DT Date(10) DATE This is the start date of the period that is to be advanced within a Calendar Period.

10 GPNZ_ADV_TO_DT Date(10) DATE This is the end date of the period that is to be advanced within a Calendar Period.

11 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.

12 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.

13 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.

14 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.

15 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.

16 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

17 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
4	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
5	END_DT	Date(10)	DATE NOT NULL	end date
6	CAL_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Calendar Sequence Number
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
9	GPNZ_ADV_FROM_DT	Date(10)	DATE	This is the start date of the period that is to be advanced within a Calendar Period.
10	GPNZ_ADV_TO_DT	Date(10)	DATE	This is the end date of the period that is to be advanced within a Calendar Period.
11	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.
12	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.
13	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.
14	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.
15	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.
16	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
17	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