PROCESS_INSTANCETRN_COSTFCT_AET(SQL Table) |
Index Back |
|---|---|
State Record for HR_TRNSPLITState Record for HR_TRNSPLIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AE_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Test Flag |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | COST_UNIT_CD | Character(10) | VARCHAR2(10) NOT NULL | Cost Unit |
| 6 | PER_UNIT_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Per Unit Cost |
| 7 | DURATION_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration (Hours) |
| 8 | FINANCED_COST_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Financed Cost |
| 9 | PAID_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Paid Hours |
| 10 | QUANTITY | Number(3,0) | SMALLINT NOT NULL | Quantity |
| 11 | DURATION_CONVERTED | Number(6,1) | DECIMAL(5,1) NOT NULL | Converted Duration |
| 12 | TOTAL_DURATION | Number(10,1) | DECIMAL(9,1) NOT NULL | Total Duration |
| 13 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |