SSR_IAM_ROOTEXT

(SQL Table)
 Index Back

IAM Root Extension

IAM Root Extension

  • Parent Record Of SSR_AM_IAM2VW SSR_AM_IAMEN2VW SSR_AM_IAMENRVW SSR_AM_IAMR2_VW SSR_AM_IAMR_VW SSR_AM_IAMVW SSR_IAM SSR_IAMRSLTCKVW SSR_IAMRSLT_VW SSR_IAM_CALC_VW SSR_IAM_RSTR3VW

    • # 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_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID

    Prompt Table: SSR_IAM_ACROTVW

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

    Default Value: 1

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

    Default Value: I

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

    Y/N Table Edit

    Default Value: N

    7 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

    8 SSR_IAM_ANONYMS_ID Number(7,0) INTEGER NOT NULL Anonymous ID
    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