HCSC_ACK_AG_VW

(SQL View)
 Index Back

Acknowledgement Transaction

Acknowledgement Transaction from activity guide.

SELECT A.PTAI_LIST_ID , A.PTAI_ITEM_ID , C.PTAI_LABEL , B.PTAI_LABEL , A.EMPLID , A.EMPL_RCD , A.HRS_PERSON_ID , A.SEQNO , A.HCSC_ESIGN_ID , A.EFFDT , A.HCSC_VERIFIED , A.FIRST_NAME , A.LAST_NAME , A.DISPLAY_NAME , A.BIRTHDATE , A.NATIONAL_ID , A.POSTAL , A.AGREE_CHECKBOX , A.USER_ID , A.NAME_DESCR , A.DTTM_STAMP , A.IP_ADDRESS FROM PS_HCSC_ESIGN_AG A , PS_PTAI_ITEM B , PS_PTAI_LIST C WHERE %Substring(A.PTAI_ITEM_ID, 1, LENGTH(A.PTAI_ITEM_ID) - LENGTH(A.PTAI_LIST_ID) - 1) = B.PTAI_ITEM_ID AND B.PTAI_LIST_ID = C.PTAI_LIST_ID AND B.PTAI_STATUS = '0'

  • Related Language Record: HCSC_ACK_AG_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    2 PTAI_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item ID
    3 HCSC_AG_DESCR Character(100) VARCHAR2(100) NOT NULL Activity Guide description
    4 HCSC_AG_STEP_DESCR Character(100) VARCHAR2(100) NOT NULL Activity Guide Step description
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    7 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    8 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

    Default Value: 0

    9 HCSC_ESIGN_ID Character(5) VARCHAR2(5) NOT NULL Acknowledgement ID
    10 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    11 HCSC_VERIFIED Character(1) VARCHAR2(1) NOT NULL Field to track if Identify Verified by User
    N=No
    Y=Yes

    Default Value: N

    12 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    13 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    14 DISPLAY_NAME Character(50) VARCHAR2(50) NOT NULL Used to display the person's name in the PERS_SRCH_SBP, EMPL_SRCH_SBP and the components that allow a person to be created
    15 BIRTHDATE Date(10) DATE Date of Birth
    16 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    17 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    18 AGREE_CHECKBOX Character(1) VARCHAR2(1) NOT NULL I Agree
    19 USER_ID Character(70) VARCHAR2(70) NOT NULL User ID
    20 NAME_DESCR Character(50) VARCHAR2(50) NOT NULL Description
    21 DTTM_STAMP 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.
    22 IP_ADDRESS Character(40) VARCHAR2(40) NOT NULL IP Address