UPG_TRNFR_AET(SQL Table) |
Index Back |
|---|---|
State Record for UpgradeState Record for Upgrade Scripts |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | COURSE | Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 4 | SESSION_NBR | Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 5 | COURSE_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 6 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 7 | CUT_SESSION_NBR | Character(4) | VARCHAR2(4) NOT NULL | Cut Session Nbr |
| 8 | TRN_HOUR_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Training Hours type |
| 9 | TRN_DIF_FRA_FLG | Character(1) | VARCHAR2(1) NOT NULL | Field for Training DIF |
| 10 | TRN_PROF_FLG_FRA | Character(1) | VARCHAR2(1) NOT NULL | Professionalisation Period Flag |
| 11 | TRN_OUTWRK_FLG_FRA | Character(1) | VARCHAR2(1) NOT NULL | Out of Working Schedule Flag |
| 12 | DURATION_CONVERTED | Number(6,1) | DECIMAL(5,1) NOT NULL | Converted Duration |
| 13 | DURATION_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration (Hours) |
| 14 | NVALUE_SHEET_1_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 1 |
| 15 | NVALUE_SHEET_2_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 2 |
| 16 | NVALUE_SHEET_3_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 3 |
| 17 | NVALUE_SHEET_4_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 4 |
| 18 | TIME_SPENT_FRA | Number(6,1) | DECIMAL(5,1) NOT NULL | Time spent at training |
| 19 | TRN_EE_DURATION_SW | Character(1) | VARCHAR2(1) NOT NULL |
Radio Button for Training Employee Duration
0=Training Duration from Session 1=Specify Student Duration |
| 20 | TRN_HOURS_FRA | Number(3,0) | SMALLINT NOT NULL | Training Hours |
| 21 | 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 |
| 22 | TRN_SCUT_STATUS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Session Cut Status
0=Awaiting Review 1=Appr by Training Administrator 2=Appr by Payroll Administrator 3=Finalized 9=Not Processed |
| 23 | TRN_SCUT_IN_HRS | Number(10,3) | DECIMAL(9,3) NOT NULL | Training Session Cut in hours |
| 24 | TRN_SCUT_OUT_HRS | Number(10,3) | DECIMAL(9,3) NOT NULL | Training Session cut out hours |
| 25 | AE_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Test Flag |
| 26 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 27 | PENS_FUND_INST_FRA | Character(4) | VARCHAR2(4) NOT NULL | Pension/Contingency Funds Institution Number (FRA) |