SSR_IAM_DATEINC

(SQL Table)
Index Back

IAM Date Inclusion

IAM Date Inclusion

  • 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_ACM_DATE_SEQ Number(3,0) SMALLINT NOT NULL Dates Sequence

    Default Value: 1

    6 SSR_ACM_START_DT Date(10) DATE Start Date
    7 SSR_ACM_DUE_DT Date(10) DATE Due Date
    8 SSR_ACM_EXDUE_DT Date(10) DATE Extended Due Date
    9 SSR_ACM_GRADE_DT Date(10) DATE Grading Date
    10 SSR_ACT_ID_ROOTXRF Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID Xref
    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