BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: AUC_BU_ASSGN_VW
AUC_PLAN_IDAUC_VERSIONAUC_TASK_NUMCO=Complete
IN=In Progress
NS=Not Started
AUC_TSK_OPR_VW(SQL View) |
Index Back |
|---|---|
Tasks by Oprid ViewTasks by Oprid View |
| SELECT A.BUSINESS_UNIT , A.AUC_PLAN_ID , A.AUC_VERSION , A.AUC_TASK_NUM , A.AUC_TASK_ID , A.AUC_TASK_STATUS , A.TASK_OWNER , A.DEADLINE_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 AND B.AUC_PLAN_TYPE = 'PL' AND B.AUC_PLAN_STATUS IN ('EX', 'PO') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: AUC_BU_ASSGN_VW |
| 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_ID | Character(100) | VARCHAR2(100) NOT NULL | Plan Task ID |
| 6 | AUC_TASK_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Task Status
CO=Complete IN=In Progress NS=Not Started |
| 7 | TASK_OWNER | Character(30) | VARCHAR2(30) NOT NULL | Task Owner |
| 8 | DEADLINE_DT | Date(10) | DATE | Deadline Date |