GP_ABS_SS_DAT (SQL Table)	Index Back
Absence SS Top Record This record is used as the main shadow record for absence self service. In order to allow the HCM Approval Framework to link to absence self service via the transaction keys as required, and to allow the SS users to edit an existing transaction by modifying the keys, we have to keep the original transaction keys the same but track the new key changes in the "Original_KeyName" fields

GP_ABS_SS_DAT

(SQL Table)

Absence SS Top Record

This record is used as the main shadow record for absence self service. In order to allow the HCM Approval Framework to link to absence self service via the transaction keys as required, and to allow the SS users to edit an existing transaction by modifying the keys, we have to keep the original transaction keys the same but track the new key changes in the "Original_KeyName" fields

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.

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
Prompt Table: GP_PIN_ABSTK_VW

6 END_DT Date(10) DATE end date

7 ORIG_EMPLID Character(11) VARCHAR2(11) NOT NULL Originating Emplid

8 ORIG_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

9 ORIG_BEGIN_DT Date(10) DATE original begin date

10 ORIG_PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

11 ORIG_END_DT Date(10) DATE Unadjusted End Date

12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

13 ELIG_GRP Character(10) VARCHAR2(10) NOT NULL eligibility group

14 HGA_WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Push Back
S=Submitted
V=Saved

15 HGA_CAN_SUB_OPTN Character(1) VARCHAR2(1) NOT NULL Submit Option
1=Approve Automatically
2=Use Absence Name Default
3=Route To A Role
4=Route To An Operator ID

16 APPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Oper ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NBR	Number(15,0)	DECIMAL(15) NOT NULL	08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
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 Prompt Table: GP_PIN_ABSTK_VW
6	END_DT	Date(10)	DATE	end date
7	ORIG_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Originating Emplid
8	ORIG_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	ORIG_BEGIN_DT	Date(10)	DATE	original begin date
10	ORIG_PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
11	ORIG_END_DT	Date(10)	DATE	Unadjusted End Date
12	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
13	ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	eligibility group
14	HGA_WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Workflow Status A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Push Back S=Submitted V=Saved
15	HGA_CAN_SUB_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Submit Option 1=Approve Automatically 2=Use Absence Name Default 3=Route To A Role 4=Route To An Operator ID
16	APPROVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver Oper ID