AUC_EWB_PLN_VW(SQL View) |
Index Back |
|---|
| SELECT A.AUC_TSK_EVENT_ID , B.AUC_PLAN_NAME FROM PS_AUC_TASK_REQ 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 | AUC_TSK_EVENT_ID | Character(10) | VARCHAR2(10) NOT NULL | Task requirement event ID |
| 2 | AUC_PLAN_NAME | Character(50) | VARCHAR2(50) NOT NULL | Plan Name |