LM_ADAPXF_HSTVW

(SQL View)
 Index Back

Approval xref for adhoc

Approval crossreference table for supplemental learning

SELECT PSARCH_ID , PSARCH_BATCHNUM , LM_ADHC_LRN_ID , EOAWTHREAD_ID , EOAWPRCS_ID , EOAWDEFN_ID , ORIGINATORID , EOAWREQUESTOR_ID , RECNAME , EOAWTHREAD_STATUS , EOAWPARENT_THREAD , EOAWDTTM_MODIFIED , COMMENTS FROM PS_LM_ADAPRXRF_HST

  • Parent record: LM_ADHC_LRN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    4 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
    5 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
    6 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
    7 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    8 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
    9 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    10 EOAWTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
    A=Approved
    C=Complete
    D=Denied
    E=Pending Denial
    H=Hard Deny
    I=Initial
    N=Not Active
    P=Pending
    S=Awaiting Further Approvals
    T=Terminated
    W=Canceled
    X=Suspended/Pending Denial

    Default Value: N

    11 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
    12 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    13 COMMENTS Long Character CLOB Comment