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

GPAU_NRP_AB4_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 ,GPAU_ADV_FROM_DT ,GPAU_ADV_TO_DT ,GPAU_SKP_FROM_DT ,GPAU_SKP_TO_DT ,GPAU_ORIG_RUNID ,GPAU_ORIG_PYMTDT ,GPAU_ORIG_PRD_ID ,CALC_TYPE ,GPAU_ADV_SPLIT_FLG FROM PS_GPAU_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 Record

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 GPAU_ADV_FROM_DT Date(10) DATE This is the start date of the period that is to be advanced within a Calendar Period.

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

11 GPAU_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 GPAU_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 GPAU_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 GPAU_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 GPAU_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 GPAU_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 Record
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	GPAU_ADV_FROM_DT	Date(10)	DATE	This is the start date of the period that is to be advanced within a Calendar Period.
10	GPAU_ADV_TO_DT	Date(10)	DATE	This is the end date of the period that is to be advanced within a Calendar Period.
11	GPAU_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	GPAU_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	GPAU_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	GPAU_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	GPAU_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	GPAU_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