HGA_CAN_EMST_VW (SQL View)	Index Back
Absence Self Service Absence Cancellation History view used for HTML email approvals.

HGA_CAN_EMST_VW

(SQL View)

Absence Self Service

Absence Cancellation History view used for HTML email approvals.

SELECT STA.TRANSACTION_NBR , STA.EMPLID , STA.EMPL_RCD , STA.BGN_DT , STA.PIN_TAKE_NUM , STA.END_DT , STA.SEQNUM , STA.OPRID , STA.EMPLID_CURR_APPR , NM.NAME , NM.NAME_DISPLAY , STA.ACTION_DT , %Sql(HR_HT_EMAIL_DATE,STA.ACTION_DT) , STA.HR_WF_ACTION , H.XLATSHORTNAME , G.XLATSHORTNAME , STA.COMMENTS FROM PS_GP_ABS_SS_STA STA LEFT OUTER JOIN PS_PERSON_NAME NM ON NM.EMPLID = STA.EMPLID_CURR_APPR , PSXLATITEM H , PSXLATITEM G WHERE H.FIELDNAME = 'HR_WF_ACTION' AND H.FIELDVALUE = STA.HR_WF_ACTION AND %EffdtCheck(PSXLATITEM,H,%CURRENTDATEIN) AND G.FIELDNAME= 'HGA_APPR_PRCS' AND G.FIELDVALUE=STA.HGA_APPR_PRCS AND %EffdtCheck(PSXLATITEM,G,%CURRENTDATEIN) AND G.EFF_STATUS='A' ORDER BY STA.TRANSACTION_NBR,STA.SEQNUM

# 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 NOT NULL 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

9 EMPLID_CURR_APPR Character(11) VARCHAR2(11) NOT NULL Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.

10 NAME Character(50) VARCHAR2(50) NOT NULL Name

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

12 ACTION_DT Date(10) DATE Action Date

13 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description

14 HR_WF_ACTION Character(3) VARCHAR2(3) NOT NULL Workflow Action
APV=Approved
CAN=Cancelled by Originator
DNY=Denied
PND=Pending
PSH=Push back for rework
RAS=Reassign
SAV=Saved For Later-Not Submitted
SUB=Submitted

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

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

17 COMMENTS Long Character CLOB Comment

#	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 NOT NULL	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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	EMPLID_CURR_APPR	Character(11)	VARCHAR2(11) NOT NULL	Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.
10	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
11	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
12	ACTION_DT	Date(10)	DATE	Action Date
13	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
14	HR_WF_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Workflow Action APV=Approved CAN=Cancelled by Originator DNY=Denied PND=Pending PSH=Push back for rework RAS=Reassign SAV=Saved For Later-Not Submitted SUB=Submitted
15	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
16	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
17	COMMENTS	Long Character	CLOB	Comment