SSR_IAMRTEXTNVW

(SQL View)
 Index Back

IAM Root Extension View

IAM Root Extension View by Root ID

SELECT EMPLID , INSTITUTION , SSR_ACTIVITY_ID , SSR_ACTIVITY_ID , SSR_ACT_ID_SEQ_NBR , SSR_ACT_ID_ROOT_ST , SSR_IAM_LOCK , SSR_CREATE_RSLTROW , SSR_IAM_ANONYMS_ID , SCC_ROW_ADD_OPRID , SCC_ROW_ADD_DTTM , SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM FROM PS_SSR_IAM_ROOTEXT

  • Parent Record Of SSR_ANONMAXSQVW SSR_IAM_ANON1VW SSR_IAM_ANON2VW SSR_IAM_ROOTVW

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

    Prompt Table: PEOPLE_SRCH

    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

    Prompt Table: SSR_IAM_ACRT2VW

    4 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    5 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number

    Default Value: 1

    6 SSR_ACT_ID_ROOT_ST Character(1) VARCHAR2(1) NOT NULL Course Root Status
    C=Completed
    I=Action Required
    X=Inactive

    Default Value: I

    7 SSR_IAM_LOCK Character(1) VARCHAR2(1) NOT NULL Locked

    Y/N Table Edit

    Default Value: N

    8 SSR_CREATE_RSLTROW Character(1) VARCHAR2(1) NOT NULL Create Initial Result Row
    N=Do Not Create Initial Result
    X=Do not use this option
    Y=Create Initial Result

    Y/N Table Edit

    Default Value: Y

    9 SSR_IAM_ANONYMS_ID Number(7,0) INTEGER NOT NULL Anonymous ID
    10 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    11 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    12 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    13 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time