HR_ADDR_PNDG

(SQL View)
 Index Back

Self service address change

Search record used for ADDRESS change PIA approval component

SELECT A.EMPLID ,A.ADDRESS_TYPE ,A.ACTION_DT_SS ,A.EFFSEQ ,A.EFF_STATUS ,A.WF_STATUS ,A.ORIGINATORID ,A.TRANSACTION_NAME ,A.UPD_BY_USERID ,A.UPD_DTTM ,A.MANUAL_UPD_USERID ,A.MANUAL_UPD_DTTM ,A.SS_STAT_INDICATOR ,A.SS_WARNING_FLG ,A.SS_FUTURE_FLG ,C.EOAWSTEP_STATUS ,D.OPRID ,D.EOAWORIG_OPRID FROM PS_HR_ADDR_CHG_DAT A , PS_HR_ADDR_XREF B , PS_EOAW_STEPINST C , PS_EOAW_USERINST D WHERE A.WF_STATUS IN ('S', 'I') AND A.EMPLID = B.EMPLID AND A.ADDRESS_TYPE = B.ADDRESS_TYPE AND A.ACTION_DT_SS = B.ACTION_DT_SS AND A.EFFSEQ = B.EFFSEQ AND B.EOAWPRCS_ID = C.EOAWPRCS_ID AND B.EOAWDEFN_ID = C.EOAWDEFN_ID AND B.EOAWTHREAD_ID = C.EOAWTHREAD_ID AND D.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

    Prompt Table: ADDRESS_TYP_TBL

    3 ACTION_DT_SS Date(10) DATE Termination Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 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
    7 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    8 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    9 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    10 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    11 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    12 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    13 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    A=Approved
    B=CI failed - Errors & Warnings
    C=Cancelled
    D=Denied
    E=Errors Encountered
    I=In Approval Process
    M=Administrator Action Required
    S=Success
    W=Warnings Encountered

    Default Value: I

    14 SS_WARNING_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    15 SS_FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    16 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
    A=Approved
    B=Pushed back
    C=Auto Approved
    D=Denied
    E=Administrator denied
    F=Deleted
    G=Bypassed
    H=On Hold
    I=No Action Taken
    K=Skipped
    L=Terminated
    M=Administrator approved
    N=Not Active
    P=Pending
    R=No longer in role
    T=Terminated
    U=Auto approved
    X=Deleted
    Z=Pending Denial
    17 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    18 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID