ESIGN_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.ESIGN_USER_ID , A.ESIGN_USER_RCD , A.SEQNO , A.ESIGN_ID , A.EFFDT , A.ESIGN_VERIFIED , A.FIRST_NAME , A.LAST_NAME , A.DISPLAY_NAME , A.BIRTHDATE , A.NATIONAL_ID , A.POSTAL , A.AGREE_CHECKBOX , A.CHECKBOX1 , A.RADIO_BUTTON , A.USER_ID , A.ESIGN_NAME_DESCR , A.DTTM_STAMP , A.IP_ADDRESS FROM PS_ESIGN_AG_DATA 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: ESIGN_ACK_AG_LV

    • # 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 ESIGN_AG_DESCR Character(100) VARCHAR2(100) NOT NULL Activity Guide description
    4 ESIGN_AG_STEP_DESC Character(100) VARCHAR2(100) NOT NULL Activity Guide Step description
    5 ESIGN_USER_ID Character(15) VARCHAR2(15) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
    6 ESIGN_USER_RCD Number(3,0) SMALLINT NOT NULL User record number
    7 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

    Default Value: 0

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

    Default Value: %date

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

    Default Value: N

    11 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
    12 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
    13 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
    14 BIRTHDATE Date(10) DATE Date of Birth
    15 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    16 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    17 AGREE_CHECKBOX Character(1) VARCHAR2(1) NOT NULL I Agree
    18 CHECKBOX1 Character(1) VARCHAR2(1) NOT NULL Check Box 1
    N=No
    Y=Yes
    19 RADIO_BUTTON Character(1) VARCHAR2(1) NOT NULL Radio button fields
    N=No
    Y=Yes
    20 USER_ID Character(70) VARCHAR2(70) NOT NULL User ID
    21 ESIGN_NAME_DESCR Character(50) VARCHAR2(50) NOT NULL Name Description
    22 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.

    Default Value: %datetime

    23 IP_ADDRESS Character(40) VARCHAR2(40) NOT NULL IP Address