SSR_IAMRTPEPTVW

(SQL View)
 Index Back

IAM PE Post View by Root

IAM Program Enroll Post View by Root

SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACT_ID_ROOTXRF , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_RSLT_SEQ , A.SSR_IAM_RSLTPST_TP , A.SSR_IAM_RSLTPST_ST , A.SCC_ROW_ADD_OPRID , A.SCC_ROW_ADD_DTTM , A.SCC_ROW_UPD_OPRID , A.SCC_ROW_UPD_DTTM FROM PS_SSR_IAM_RSLTPST A WHERE A.SSR_IAM_RSLTPST_TP = 'P'

  • Parent record: SSR_IAM_ROOTVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
    4 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID

    Prompt Table: SSR_ACT_ROOTEXT

    5 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number

    Default Value: 1

    6 SSR_RSLT_SEQ Number(3,0) SMALLINT NOT NULL Result Sequence Nbr

    Default Value: 1

    7 SSR_IAM_RSLTPST_TP Character(1) VARCHAR2(1) NOT NULL Result Post Type
    P=Program Enroll
    S=Student Enroll
    8 SSR_IAM_RSLTPST_ST Character(1) VARCHAR2(1) NOT NULL Student Enrollment Post Status
    C=Grade Changed
    E=Error
    K=Rejected
    L=Locked APT
    N=Not Applicable
    P=Posted
    U=Updated
    X=Pending
    Z=Not Paired
    9 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    10 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    11 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    12 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time