SS_DTL_TRAINING(SQL Table) |
Index Back |
|---|---|
Detail SS Adm Training RequestDetail data that is specific to the Training Request transaction used on the WF_SS_Staged Page. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 2 | SS_GRP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Key Used in SS Framework |
| 3 | SS_TRANS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Key Used in SS Framework |
| 4 | SS_PROCESS_CYCLE |
Number(3,0) | SMALLINT NOT NULL | Used in SS Framework |
| 5 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 6 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 7 | 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 |
| 8 | WAITLIST | Character(1) | VARCHAR2(1) NOT NULL |
Waitlist if Couse is Full
Y/N Table Edit |