CRS_SESSDTS_LNG(SQL Table) |
Index Back |
|---|---|
Training Course SessionsCRSE_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. |
| # | 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 | Character(6) | VARCHAR2(6) NOT NULL |
Facility
Prompt Table: %RECNAME_EDIT |
| 6 | FACILITY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Facility Name |
| 7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: SCC_CNT_ADFMTVW |
| 8 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 9 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 10 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 11 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 12 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 13 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 14 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 15 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 16 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 17 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 18 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 19 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 20 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 21 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 22 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 23 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 24 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |