CRSE_LST_DTL_SF

(SQL Table)
Index Back

Course List Detail

  • Parent record: CRSE_LST_HDR_SF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: CRSE_LST_HDR_SF.SETID

    Prompt Table: CRSE_LST_HDR_SF

    2 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List

    Default Value: CRSE_LST_HDR_SF.COURSE_LIST

    Prompt Table: CRSE_LST_HDR_SF

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: CRSE_LST_HDR_SF.EFFDT

    4 CRSE_LIST_SEQNO Number(6,0) INTEGER NOT NULL Course List Sequence Number
    5 WILDCARD_IND Character(1) VARCHAR2(1) NOT NULL WildCard Indicator

    Y/N Table Edit

    Default Value: N

    6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    7 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    8 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    9 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CAT_R1_VW