PROCESS_INSTANCEH=Hours
I=Incident
N=No
Y=Yes
N=No
Y=Yes
EXP=Expense Transaction
INC=Incident Transaction
INV=Invoice Transaction
TIM=Time Transaction
SPA_PRJ_EXP_AET(SQL Table) |
Index Back |
|---|---|
sPro Projects Export State RecsPro Projects Export State Record |
| # | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | CONTRACTOR | Character(15) | VARCHAR2(15) NOT NULL | Contractor |
| 7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 8 | HIRING_MANAGER | Character(30) | VARCHAR2(30) NOT NULL | Hiring Manager |
| 9 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 10 | END_DATE | Date(10) | DATE | End Date |
| 11 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 12 | WORK_ORD_FROM | Character(15) | VARCHAR2(15) NOT NULL | Work Order Id |
| 13 | WORK_ORD_TO | Character(15) | VARCHAR2(15) NOT NULL | Work Order Id |
| 14 | PO_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL | From/To |
| 15 | PO_ID_TO | Character(10) | VARCHAR2(10) NOT NULL | PO_ID in a range |
| 16 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 17 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code |
| 18 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 19 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 20 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 21 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 22 | RES_ID_LAST_USED | Number(10,0) | DECIMAL(10) NOT NULL | Resource ID last used for sPro Projects Integration |
| 23 | UOM_HOURS | Character(3) | VARCHAR2(3) NOT NULL | The Unit of Measure that represents Hours. |
| 24 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |
| 25 | ADJUST_DTTM | DateTime(26) | TIMESTAMP | Adjust Date and Time |
| 26 | TIME_LINE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Time Line Type
H=Hours I=Incident |
| 27 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 28 | TAX_VAT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include VAT
N=No Y=Yes |
| 29 | PROVIDER_CONTACT | Character(15) | VARCHAR2(15) NOT NULL | PROVIDER CONTACT |
| 30 | SPA_TE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Time/Expense/Incident type
EXP=Expense Transaction INC=Incident Transaction INV=Invoice Transaction TIM=Time Transaction |