CRS_SESSDTS_LNG

(SQL Table)
 Index Back

Training Course Sessions

CRSE_SESS_DATES is a child record of CRSE_SESSN_TBL, and effectively contains the schedule of dates & times for the course session. This record has been introduced to allow training administrators to define course sessions that do not run on consecutive days. It also allows the system to gain more intelligence about when training rooms/instructors are booked. This record is part of the Training Administration module.

  • Related Language Record for CRSE_SESS_DATES

  • Parent record: CRSE_SESSN_TBL

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

    Default Value: CRSE_SESSN_TBL.COURSE

    Prompt Table: CRSE_SESSN_SRCH

    2 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr

    Default Value: CRSE_SESSN_TBL.SESSION_NBR

    3 CUT_SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Cut Session Nbr

    Default Value: 1

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 FACILITY_NAME Character(30) VARCHAR2(30) NOT NULL Facility Name
    6 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    13 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    14 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    15 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    16 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    17 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility