SAD_ADA_SUS_CD

(SQL Table)
Index Back

AADSAS Suspense Course Detail

This contains all the course work detail information from the different sessions.

  • Parent record: SAD_ADA_SUS_CS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
    2 TEST_REC_NBR Number(9,0) DECIMAL(9) NOT NULL Test Type Record Nbr
    3 CRSE_SESSN_NBR Number(2,0) SMALLINT NOT NULL Course Number
    4 CRSE_NBR Number(2,0) SMALLINT NOT NULL Course Number
    5 SESSN_STATS_AADSAS Character(30) VARCHAR2(30) NOT NULL AADSAS Session Status
    6 CRSE_CODE_AADSAS Character(4) VARCHAR2(4) NOT NULL AADSAS Course Code
    7 CRSE_TYPE_AADSAS Character(1) VARCHAR2(1) NOT NULL AADSAS Course Type
    8 CRSE_GPA_AADSAS Character(2) VARCHAR2(2) NOT NULL AADSAS GPA
    9 CRSE_HRS_AADSAS Character(3) VARCHAR2(3) NOT NULL AADSAS Hours
    10 COLG_CODE_AADSAS Character(6) VARCHAR2(6) NOT NULL College Code
    11 SAD_ADA_CD_REC_NBR Character(7) VARCHAR2(7) NOT NULL AADSAS Course Record Number
    12 COL_NAME_AADSAS Long Character(255) VARCHAR2(255) College Name
    13 SAD_AADSAS_TERM Character(10) VARCHAR2(10) NOT NULL AADSAS Term
    14 TERM_TYPE_AADSAS Character(10) VARCHAR2(10) NOT NULL AADSAS Term Type
    15 SAD_START_YR Character(4) VARCHAR2(4) NOT NULL AADSAS Start Year
    16 SAD_CRS_TITLE Character(40) VARCHAR2(40) NOT NULL AADSAS Course Title
    17 SAD_CRS_PREFIX_NBR Character(25) VARCHAR2(25) NOT NULL AADSAS Prefix
    18 SAD_CRS_LVL_ABR Character(5) VARCHAR2(5) NOT NULL AADSAS Course Level
    19 SAD_CRS_LVL Character(30) VARCHAR2(30) NOT NULL AADSAS Course Level
    20 SAD_CRS_GPA Character(6) VARCHAR2(6) NOT NULL AADSAS Course GPA
    21 SAD_AADSAS_CONV_GP Character(4) VARCHAR2(4) NOT NULL AADSAS Grade
    22 SAD_AADSAS_GRD_WGT Character(3) VARCHAR2(3) NOT NULL AADSAS Grade Weightage
    23 SAD_CREDIT_HRS Character(5) VARCHAR2(5) NOT NULL AADSAS Credit Hours
    24 SAD_VERIFY_GRD Character(4) VARCHAR2(4) NOT NULL AADSAS Grade Verify
    25 SAD_VERIFY_CREDIT Character(3) VARCHAR2(3) NOT NULL AADSAS Credit Verify
    26 SAD_CRS_SUB_CODE Character(3) VARCHAR2(3) NOT NULL AADSAS Subject Code
    27 SAD_CRS_SUB_DESCR Character(30) VARCHAR2(30) NOT NULL AADSAS Subject Description
    28 SAD_SPEC_CLASS_CD Character(2) VARCHAR2(2) NOT NULL AADSAS Spec Class
    29 SAD_SPEC_CLASS_NAM Character(50) VARCHAR2(50) NOT NULL AADSAS Spec Class Name
    30 SAD_AADSAS_AUDIT Character(3) VARCHAR2(3) NOT NULL AADSAS Audit Status