GRP_AP_PST_VW1(SQL View) |
Index Back |
|---|---|
AP Control Group Post View |
| SELECT DISTINCT A.BUSINESS_UNIT , A.GRP_AP_ID , A.GRP_AP_STATUS , A.ASSIGNED_TO_OPRID , A.DTTM_ASSIGNED , A.POST_ACTION_AP FROM PS_GRP_AP A WHERE A.GRP_AP_STATUS = 'V' AND EXISTS ( SELECT 'X' FROM PS_VOUCHER WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND GRP_AP_ID = A.GRP_AP_ID AND POST_STATUS_AP = 'U' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 2 | GRP_AP_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Control Group ID
Prompt Table: GRP_AP |
| 3 | GRP_AP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of Control Group
A=Assigned E=Entry Set Aside O=Open R=Ready for Review S=Supervisor Set Aside V=Verified |
| 4 | ASSIGNED_TO_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Assigned to
Prompt Table: OPR_AP_VW |
| 5 | DTTM_ASSIGNED | DateTime(26) | TIMESTAMP | Date/Time Assigned |
| 6 | POST_ACTION_AP | Character(1) | VARCHAR2(1) NOT NULL |
Post Group
D=Post on a Deferred basis N=Do Not Post P=Post Immediately Default Value: N |