SPF_WOALERT_AET(SQL Table) |
Index Back |
|---|---|
WorkOrder AlertWorkOrder Alert |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 4 | WO_NOTIFY_BY | Character(2) | VARCHAR2(2) NOT NULL |
WorkOrder Alert Notification Method
EM=Email and Worklist WL=Worklist Only |
| 5 | SP_DSTRLST_ID | Character(18) | VARCHAR2(18) NOT NULL | Distribution List ID |
| 6 | SP_USE_WO_ALERTS | Character(1) | VARCHAR2(1) NOT NULL |
Using Work Order Alerts flag
N=No Y=Yes |
| 7 | SP_ALERT_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Alert Sequence Number |
| 8 | SP_WO_ALERT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Alert Type
A=Days After B=Days Before C=Percent Consumed |
| 9 | SP_ALERT_NUM_DAYS | Number(3,0) | SMALLINT NOT NULL | Number of Days/% Consumed |
| 10 | SP_ALERT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Alert Description |
| 11 | SP_ALRT_TRIG_EVENT | Character(2) | VARCHAR2(2) NOT NULL |
Alert Triggering Event
AE=Actual End Date AP=Approval Date AS=Actual Start Date CL=Closed Date CN=Cancel Date EN=Entered Date PE=Projected End Date PS=Projected Start Date RE=Released Date TE=Terminated Date |
| 12 | WO_CLIID | Character(30) | VARCHAR2(30) NOT NULL | Requester |
| 13 | TE_APPROVER | Character(30) | VARCHAR2(30) NOT NULL | Time Approver |
| 14 | INVAPPROVER | Character(30) | VARCHAR2(30) NOT NULL | Invoice Approver |
| 15 | ROW_CREATE_USER | Character(30) | VARCHAR2(30) NOT NULL | Row Added By |
| 16 | RECRUITER | Character(15) | VARCHAR2(15) NOT NULL | Service Coordinator |
| 17 | SP_ROUTE_TO | Character(30) | VARCHAR2(30) NOT NULL | WorkOrder Approver Person. |
| 18 | TEAM_ID | Character(15) | VARCHAR2(15) NOT NULL | Team ID |
| 19 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 20 | END_DATE | Date(10) | DATE | End Date |
| 21 | ACT_START_DT | Date(10) | DATE | Activity Start Date |
| 22 | ACT_END_DT | Date(10) | DATE | Activity End Date |
| 23 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP | Row Creation Date Time |
| 24 | WO_CONID | Character(15) | VARCHAR2(15) NOT NULL | Service Provider's ID assigned on work order |
| 25 | POAMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Purchase Order / Work Order Amount |
| 26 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 27 | COUNTER2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 2 |
| 28 | COUNTER3 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 3 |
| 29 | SP_HCM_DEFLT_ADMIN | Character(30) | VARCHAR2(30) NOT NULL | Default HCM Administrator |
| 30 | SP_EXP_APPROVER | Character(30) | VARCHAR2(30) NOT NULL | Expense Approver |