GP_ABS_APPRVW_L

(SQL View)
 Index Back

Absence SS Top Record-Rel Lang

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

SELECT A.TRANSACTION_NBR , A.EMPLID , A.EMPL_RCD , A.BGN_DT , A.PIN_TAKE_NUM , A.END_DT , B.LANGUAGE_CD , B.JOBTITLE , C.DESCR FROM PS_GP_ABS_APPR_VW A , PS_GP_SS_EE_RCD_LV B , PS_GP_PIN_LANG C WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND C.PIN_NUM = A.ORIG_PIN_TAKE_NUM

  • Related Language Record for GP_ABS_APPR_VW

    • # 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 Rcd Nbr
    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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description