SSR_APT_HDR

(SQL Table)
 Index Back

APT Header

  • Parent Record Of SSR_APT_CRSE_V2 SSR_APT_CRSE_VW SSR_APT_HDR_ADD SSR_APT_ITEM SSR_APT_ITEM_V2 SSR_APT_ITEM_V3 SSR_APT_ITEM_VW SSR_APT_ITM_VW1 SSR_APT_ITM_VW2 SSR_APT_RTKA_VW SSR_APT_RTKC_VW SSR_APT_RTK_VW SSR_APT_TIMETBL SSR_APT_TTBL_WR

    • # 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_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number

    Default Value: 1

    4 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: STDNT_CAREER_V2

    5 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

    Prompt Table: SSR_STU_CAR_PRG

    6 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN

    7 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID

    Prompt Table: SSR_AIR_PRG_VW

    8 SSR_APT_STATUS Character(2) VARCHAR2(2) NOT NULL Instance Status
    10=Active
    20=Inactive

    Default Value: 10

    9 SSR_ADVR_APPR_STAT Character(4) VARCHAR2(4) NOT NULL Advisor Approval Status
    20=Not Required
    40=Pending
    60=Approved
    80=Denied
    10 SSR_COHORT_ID Character(12) VARCHAR2(12) NOT NULL Cohort Tag

    Prompt Table: SSR_COHORT_TBL

    11 SSR_COHORT_TERM Character(4) VARCHAR2(4) NOT NULL Cohort Term

    Prompt Table: SSR_COH_CRIT_VW

    12 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Curriculum Term

    Prompt Table: TERM_TBL

    13 FREEZE_REC_FL Character(1) VARCHAR2(1) NOT NULL Instance Locked

    Y/N Table Edit

    Default Value: N

    14 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    15 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    16 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    17 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time