SSR_APT_SUBS_VW

(SQL View)
Index Back

APT Substitution View


SELECT a.EMPLID , a.INSTITUTION , a.SSR_APT_INSTANCE , a.SSR_APT_ITEM_SEQ , a.SSR_APT_ITEM_SUB , b.SSR_ITEM_ID FROM PS_SSR_APT_SUBS a , PS_SSR_APT_ITEM b WHERE a.EMPLID = b.EMPLID AND a.INSTITUTION = b.INSTITUTION AND a.SSR_APT_INSTANCE = b.SSR_APT_INSTANCE AND a.SSR_APT_ITEM_SUB = b.SSR_APT_ITEM_SEQ

  • 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_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID