CRSE_SESSN_E_VW

(SQL View)
 Index Back

Training Course Sessions

CRSE_SESSN_TBL contains one record for each session of an in-house administered course. Sessions are automa

SELECT COURSE , SESSION_NBR , SESSION_STATUS , COURSE_START_DT , COURSE_END_DT , RESCHEDULED , DURATION_TIME , DURATION_CONVERTED , DURATION_UNIT_CD , SESSN_START_TIME , SESSN_END_TIME , SESSION_LANGUAGE , MIN_STUDENTS , MAX_STUDENTS , SESSN_ORGANIZER FROM PS_CRSE_SESSN_TBL

  • Parent record: COURSE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COURSE Character(6) VARCHAR2(6) NOT NULL Catalog Item

    Prompt Table: CRSE_SESSN_SRCH

    2 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Activity Code

    Default Value: 0

    3 SESSION_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
    A=Active
    C=Complete
    N=Cancelled

    Default Value: A

    4 COURSE_START_DT Date(10) DATE NOT NULL Activity Start Date
    5 COURSE_END_DT Date(10) DATE Activity End Date
    6 RESCHEDULED Character(1) VARCHAR2(1) NOT NULL Rescheduled

    Y/N Table Edit

    Default Value: N

    7 DURATION_TIME Number(6,1) DECIMAL(5,1) NOT NULL Duration Time

    Default Value: COURSE_TBL.DURATION_TIME

    8 DURATION_CONVERTED Number(6,1) DECIMAL(5,1) NOT NULL Converted Duration

    Default Value: COURSE_TBL.DURATION_CONVERTED

    9 DURATION_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Duration Unit

    Default Value: COURSE_TBL.COST_UNIT_CD

    Prompt Table: DT_COST_UNIT_VW

    10 SESSN_START_TIME Time(15) TIMESTAMP Start Time
    11 SESSN_END_TIME Time(15) TIMESTAMP End Time
    12 SESSION_LANGUAGE Character(8) VARCHAR2(8) NOT NULL Session Langue
    CFR=Canadian French
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    INE=International English
    JPN=Japanese
    POR=Portuguese

    Prompt Table: LANGUAGE_VW

    13 MIN_STUDENTS Number(3,0) SMALLINT NOT NULL Minimum Nbr of Students

    Default Value: COURSE_TBL.MIN_STUDENTS

    14 MAX_STUDENTS Number(3,0) SMALLINT NOT NULL Maximum Nbr of Students

    Default Value: COURSE_TBL.MAX_STUDENTS

    15 SESSN_ORGANIZER Character(1) VARCHAR2(1) NOT NULL Session Administration

    Y/N Table Edit

    Default Value: Y