| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COURSE |
Character(6) |
VARCHAR2(6) NOT NULL |
Course Code
Prompt Table:
CRSE_SESSN_SRCH
|
| 2 |
SESSION_NBR |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Session Nbr
Default Value: 0
|
| 3 |
SESSION_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Session Status
A=Active
C=Complete
N=Cancelled
Default Value: A
|
| 4 |
COURSE_START_DT |
Date(10) |
DATE NOT NULL |
Course Start Date
|
| 5 |
COURSE_END_DT |
Date(10) |
DATE |
Course 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
|