SSR_IAM_CONTITM

(SQL Table)
 Index Back

IAM Assignment Extension

IAM Assignment Extension

  • Parent record: SSR_IAM

    • # 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
    3 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    4 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number

    Default Value: 1

    5 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale

    Prompt Table: SSR_RES_MAP_VW5

    6 SSR_CW_OVRD_GRDMAP Character(1) VARCHAR2(1) NOT NULL Override Result ID

    Y/N Table Edit

    7 SSR_CW_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Weighting Multiplier
    8 ASSESSED Character(1) VARCHAR2(1) NOT NULL Assessed

    Y/N Table Edit

    9 SSR_ACT_ID_ROOTCON Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID Cont
    10 SSR_INCL_IN_CALC Character(1) VARCHAR2(1) NOT NULL Include in Calculation

    Y/N Table Edit

    Default Value: Y

    11 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    12 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    13 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    14 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time