SSR_APT_SUBS

(SQL Table)
Index Back

APT Substitution Table

  • Parent record: SSR_APT_ITEM
  • # 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_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number
    4 SSR_APT_ITEM_SEQ Number(6,0) INTEGER NOT NULL APT Item Seq
    5 SSR_APT_ITEM_SUB Number(6,0) INTEGER NOT NULL APT Item Substituted With
    6 SSR_APT_SYN_ADDFLG Character(1) VARCHAR2(1) NOT NULL APT Sync Added Flag
    7 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    8 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    9 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    10 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time