HGA_SS_DAT_VW (SQL View)	Index Back
Absence SS Top Record This record is used to track Absence Enteries which gets deleted. This is used in Absence Insights Analytics

HGA_SS_DAT_VW

(SQL View)

Absence SS Top Record

This record is used to track Absence Enteries which gets deleted. This is used in Absence Insights Analytics

SELECT TRANSACTION_NBR , EMPLID , EMPL_RCD , BGN_DT , PIN_TAKE_NUM , END_DT , ORIG_EMPLID , ORIG_EMPL_RCD , ORIG_BEGIN_DT , ORIG_PIN_TAKE_NUM , ORIG_END_DT , COUNTRY , ELIG_GRP , HGA_WF_STATUS , HGA_CAN_SUB_OPTN , APPROVER_OPRID ,%CurrentDateTimeOut FROM PS_GP_ABS_SS_DAT

# 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

17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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
17	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.