HGA_CB_ABREQ_VW (SQL View)	Index Back
Chatbot - Absence Requests Chatbot - Absence Requests View

HGA_CB_ABREQ_VW

(SQL View)

Chatbot - Absence Requests

Chatbot - Absence Requests View

SELECT A.EMPLID , A.EMPL_RCD , A.DESCR , A.ORIG_BEGIN_DT , A.ORIG_END_DT , A.DURATION_ABS , A.PIN_TAKE_NUM , A.TRANSACTION_NBR , D.ORIG_EMPLID , NM.NAME_DISPLAY , B.XLATLONGNAME , C.XLATLONGNAME , A.COUNTRY , A.WF_STATUS , A.ABSENCE_REASON , A.COMMENTS FROM PS_GP_ABSHISTSS_VW A , PS_NAMES NM , PS_GP_ABS_SS_DAT D , PSXLATITEM B , PSXLATITEM C WHERE A.TRANSACTION_NBR = D.TRANSACTION_NBR AND A.EMPLID = D.EMPLID AND A.EMPL_RCD = D.EMPL_RCD AND A.BGN_DT = D.BGN_DT AND A.PIN_TAKE_NUM = D.PIN_TAKE_NUM AND A.END_DT = D.END_DT AND NM.EMPLID = A.EMPLID AND NM.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES NM1, NM, %CurrentDateIn) AND B.FIELDNAME = 'WF_STATUS' AND B.FIELDVALUE = A.WF_STATUS AND B.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM B1, B, %CurrentDateIn) AND C.FIELDNAME = 'UNIT_TYPE' AND C.FIELDVALUE = A.UNIT_TYPE AND C.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM C1, C, %CurrentDateIn)

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 ORIG_BEGIN_DT Date(10) DATE original begin date

5 ORIG_END_DT Date(10) DATE Unadjusted End Date

6 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements

7 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

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

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

10 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

11 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

12 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2

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

14 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=Rework
S=Submitted
V=Data Saved

15 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason

16 COMMENTS Long Character CLOB Comment

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	ORIG_BEGIN_DT	Date(10)	DATE	original begin date
5	ORIG_END_DT	Date(10)	DATE	Unadjusted End Date
6	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
7	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
8	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.
9	ORIG_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Originating Emplid
10	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
11	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
12	DESCR2	Character(30)	VARCHAR2(30) NOT NULL	Descr2
13	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
14	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=Rework S=Submitted V=Data Saved
15	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason
16	COMMENTS	Long Character	CLOB	Comment