SSR_APT_RQ_RLVW

(SQL View)
 Index Back

APT Request History List

Related Language for APT Request History List

SELECT A.OPRID , A.RUN_CNTL_ID , A.PROCESS_INSTANCE , A.INSTITUTION , A.SSR_APT_ACTION , A.SSR_ITEM_ID , A.SSR_ITEM_ID_1 , A.SSR_ITEM_ID_2 , A.SSR_RSLT_TYPE , A.SSR_RES_MAP_ID , A.SSR_ENRL_CAT , %Coalesce(B.RUNDTTM , ( SELECT MIN(D.SCC_ROW_ADD_DTTM) FROM %Table(SSR_APT_ADM_RC2) C , %Table(SSR_APT_REQUEST) D WHERE C.SSR_APT_REQUEST_ID = D.SSR_APT_REQUEST_ID AND C.RUN_CNTL_ID = A.RUN_CNTL_ID GROUP BY C.RUN_CNTL_ID)) , B.RUNSTATUS , B.PRCSNAME , E.LANGUAGE_CD , A.SSR_DESCR100 , E.DESCR60 , E.DESCR50 , E.DESCR50_1 FROM %Table(SSR_APT_ADMRQRC) A LEFT JOIN %Table(PSPRCSRQST) B ON A.PROCESS_INSTANCE = B.PRCSINSTANCE , %Table(SSR_APT_ADMR_RL) E WHERE A.OPRID = E.OPRID AND A.RUN_CNTL_ID = E.RUN_CNTL_ID

  • Related Language Record for SSR_APT_REQ_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    5 SSR_APT_ACTION Character(3) VARCHAR2(3) NOT NULL APT Request Action
    ACT=Activate Planning Node
    AIT=Add Item
    ASE=APT Status Evaluation
    CAT=Create Ins & Plan Node Attempt
    CNA=Create Plan Node(s)
    CRS=Calculate Results
    CRT=Create Instance
    CSB=Create Substitution
    DEL=Delete Planning Node
    EAS=Enter APT Status
    ENR=Enrollment
    ERS=Enter Results
    RIT=Remove Item
    SHC=Shopping Cart
    6 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID
    7 SSR_ITEM_ID_1 Character(11) VARCHAR2(11) NOT NULL Academic Item ID
    8 SSR_ITEM_ID_2 Character(11) VARCHAR2(11) NOT NULL Academic Item ID
    9 SSR_RSLT_TYPE Character(20) VARCHAR2(20) NOT NULL Result Type
    10 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale
    11 SSR_ENRL_CAT Character(4) VARCHAR2(4) NOT NULL Enrollment Category
    12 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
    13 RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
    1=Cancel
    10=Not Successful
    11=Posted
    12=Unable to post
    13=Resend
    14=Posting
    15=Content Generated
    16=Pending
    17=Success With Warning
    18=Blocked
    19=Restart
    2=Delete
    3=Error
    4=Hold
    5=Queued
    6=Initiated
    7=Processing
    8=Cancelled
    9=Success
    14 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

    Prompt Table: PRCSDEFN

    15 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    16 SSR_DESCR100 Character(100) VARCHAR2(100) NOT NULL Topic
    17 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    18 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    19 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50