GPAU_ABS_R_HST (SQL Table)	Index Back
Payslip Absence result values This is the Archive (history/shadow) table used in Data Archiving for the record: GPAU_ABS_RSLT.

GPAU_ABS_R_HST

(SQL Table)

Payslip Absence result values

This is the Archive (history/shadow) table used in Data Archiving for the record: GPAU_ABS_RSLT.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

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

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

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

8 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

9 GPAU_ACUM_VAL1 Signed Number(20,6) DECIMAL(18,6) NOT NULL This field will be used to store the value of accumulator 1 used for on-line and hard-copy payslips.

10 GPAU_ACUM_VAL2 Signed Number(20,6) DECIMAL(18,6) NOT NULL This field will be used to store the value of accumulator 2 used for on-line and hard-copy payslips.

11 GPAU_ACUM_VAL3 Signed Number(20,6) DECIMAL(18,6) NOT NULL This field will be used to store the value of accumulator 3 used for on-line and hard-copy payslips.

12 GPAU_ACUM_VAL4 Signed Number(20,6) DECIMAL(18,6) NOT NULL This field will be used to store the value of accumulator 4 used for on-line and hard-copy payslips

13 GPAU_DESC_TYPE Character(2) VARCHAR2(2) NOT NULL This field will be used to identify which of the earnings/deductions description will be included on the on-line and hard-copy payslips. The options are Element Description, Element Name, or Custom (user entered).
10=Description
20=Custom
30=Element Name
40=Recipient Name

14 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
9	GPAU_ACUM_VAL1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store the value of accumulator 1 used for on-line and hard-copy payslips.
10	GPAU_ACUM_VAL2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store the value of accumulator 2 used for on-line and hard-copy payslips.
11	GPAU_ACUM_VAL3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store the value of accumulator 3 used for on-line and hard-copy payslips.
12	GPAU_ACUM_VAL4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store the value of accumulator 4 used for on-line and hard-copy payslips
13	GPAU_DESC_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field will be used to identify which of the earnings/deductions description will be included on the on-line and hard-copy payslips. The options are Element Description, Element Name, or Custom (user entered). 10=Description 20=Custom 30=Element Name 40=Recipient Name
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description