TRAINING012_AET(SQL Table) |
Index Back |
|---|---|
TRN012 Cache RecordAdminister Training Application Engine state record for HR_TRNACTUA process that updates planned and real costs. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | AE_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Test Flag |
| 5 | BUDGET_PERIOD | Character(10) | VARCHAR2(10) NOT NULL | Budget Period |
| 6 | FZN_BUDGET_BUSUNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | LOCAL_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | SCENARIO | Character(10) | VARCHAR2(10) NOT NULL | Scenario |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 11 | LOCAL_DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Billed on Department |
| 12 | COURSE | Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 13 | SESSION_NBR | Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 14 | DURATION_CONVERTED | Number(6,1) | DECIMAL(5,1) NOT NULL | Converted Duration |
| 15 | COMPUTED_DURATION | Number(6,1) | DECIMAL(5,1) NOT NULL | Converted Duration |
| 16 | DEMAND_ID | Character(10) | VARCHAR2(10) NOT NULL | Demand ID |
| 17 | DEMAND_APPROVED | Number(6,0) | INTEGER NOT NULL | Employees Approved |
| 18 | COMPUTED_APPROVED | Number(6,0) | INTEGER NOT NULL | Employees Approved |
| 19 | DEPT_DEMAND | Number(6,0) | INTEGER NOT NULL | Department Demand |
| 20 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 21 | COST_UNIT_CD | Character(10) | VARCHAR2(10) NOT NULL | Cost Unit |
| 22 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Base Currency |
| 23 | EFFDT | Date(10) | DATE | Effective Date |
| 24 | EXCHNG_TO_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | To Currency |
| 25 | EXCHNG_TO_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 26 | FIXED_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Fixed Cost |
| 27 | VARIABLE_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Variable Cost |
| 28 | COMPUTED_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Variable Cost |
| 29 | AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Dollar Amount |
| 30 | COST_VAR1 | Number(19,3) | DECIMAL(18,3) NOT NULL | Variable Cost |
| 31 | 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 |
| 32 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 33 | COURSE_END_DT | Date(10) | DATE | Course End Date |
| 34 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 35 | COURSE_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 36 | EE_QUANTITY | Number(6,2) | DECIMAL(5,2) NOT NULL | Per Employee Quantity |
| 37 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 38 | LISTED_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Projected Cost |
| 39 | BUDGETED_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Budgeted Cost |
| 40 | ACTUAL_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Actual Cost |
| 41 | NBGT_ACTUAL_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Unbudgeted Actual Cost |
| 42 | NBGT_LISTED_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Unbudgeted Projected Cost |
| 43 | LISTED_DEMAND | Number(6,0) | INTEGER NOT NULL | Projected Demand |
| 44 | LISTED_DURTN | Number(10,1) | DECIMAL(9,1) NOT NULL | Projected Duration |
| 45 | ACTUAL_DEMAND | Number(6,0) | INTEGER NOT NULL | Actual Demand |
| 46 | ACTUAL_DURTN | Number(10,1) | DECIMAL(9,1) NOT NULL | Actual Duration |
| 47 | NBGT_LISTED_DEMAND | Number(6,0) | INTEGER NOT NULL | Unbudgeted Projected Demand |
| 48 | NBGT_LISTED_DURTN | Number(10,1) | DECIMAL(9,1) NOT NULL | Unbudgeted Projected Duratn |
| 49 | NBGT_ACTUAL_DURTN | Number(10,1) | DECIMAL(9,1) NOT NULL | Unbudgeted Actual Duration |
| 50 | NBGT_ACTUAL_DEMAND | Number(6,0) | INTEGER NOT NULL | Unbudgeted Actual Demand |
| 51 | TOTAL_DURATION | Number(10,1) | DECIMAL(9,1) NOT NULL | Total Duration |
| 52 | TOTAL_EMPLOYEES | Number(5,0) | INTEGER NOT NULL | Total Employees |