BUSINESS_UNITAUC_PLAN_IDAUC_VERSIONAUC_TASK_NUMCO=Complete
IN=In Progress
NS=Not Started
AP=Approved
CA=Cancelled
CO=Completed
EX=Executing
IN=Inactive
NE=New
PE=Pending Approval
PO=Posted
AUC_TSK_VTR_VW(SQL View) |
Index Back |
|---|---|
Task By Resource ViewTask By Resource View |
| SELECT A.BUSINESS_UNIT , A.AUC_PLAN_ID , A.AUC_VERSION , A.AUC_TASK_NUM , A.AUC_TASK_STATUS , TASK_OWNER , B.AUC_PLAN_STATUS , A.START_DT , A.END_DT FROM PS_AUC_PLAN_TASKS A , PS_AUC_PLAN_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_PLAN_ID = B.AUC_PLAN_ID AND A.AUC_VERSION = B.AUC_VERSION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | AUC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Sourcing Planning ID |
| 3 | AUC_VERSION |
Number(5,0) | INTEGER NOT NULL | Event Version |
| 4 | AUC_TASK_NUM |
Number(3,0) | SMALLINT NOT NULL | Task number |
| 5 | AUC_TASK_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Task Status
CO=Complete IN=In Progress NS=Not Started |
| 6 | TASK_OWNER | Character(30) | VARCHAR2(30) NOT NULL | Task Owner |
| 7 | AUC_PLAN_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Sourcing Plan Status
AP=Approved CA=Cancelled CO=Completed EX=Executing IN=Inactive NE=New PE=Pending Approval PO=Posted |
| 8 | START_DT | Date(10) | DATE | Start Date |
| 9 | END_DT | Date(10) | DATE | End Date |