TRN_RESCHED_VW(SQL View) |
Index Back |
|---|---|
Trn Course-ReschedulingTRN_RESCHED_VW is a view of TRAINING data used to reschedule students from session to session within a course in one step. This functionality is part of the Training Administration application. |
| SELECT COURSE ,SESSION_NBR ,EMPLID ,ATTENDANCE ,COURSE_START_DT ,COURSE_END_DT ,STATUS_DT ,WAIT_DT ,LETTER_CD ,LETTER_PRINTED_DT FROM PS_TRAINING WHERE ATTENDANCE IN ('E','W','S') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 2 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL |
Course Session Nbr
Prompt Table: CRSE_SESSN_VW |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 4 | ATTENDANCE | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment/Attendance
A=Currently Attending C=Completed D=Dropped E=Enrolled I=Incomplete L=Cancelled N=No Show O=Training Request Approved P=Need for Career Plan R=Request S=Session Waitlist T=Need for Training Program U=Training Request Authorized W=Course Waitlist X=Cancel Request for Training |
| 5 | COURSE_START_DT | Date(10) | DATE |
Course Start Date
Default Value: CRSE_SESSN_TBL.COURSE_START_DT |
| 6 | COURSE_END_DT | Date(10) | DATE |
Course End Date
Default Value: CRSE_SESSN_TBL.COURSE_END_DT |
| 7 | STATUS_DT | Date(10) | DATE | Status Date |
| 8 | WAIT_DT | Date(10) | DATE | Waitlist Entry Date |
| 9 | LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL |
Letter code
Prompt Table: TRN_STD_LTR_VW |
| 10 | LETTER_PRINTED_DT | Date(10) | DATE | Date letter was printed |