BUSINESS_UNITOPRIDVCH_GRP_DFLT_VW(SQL View) |
Index Back |
|---|---|
AP Vchr Entry Ctrl Grp Dflt Vw |
| SELECT A.BUSINESS_UNIT , A.ASSIGNED_TO_OPRID , A.GRP_AP_ID FROM PS_GRP_AP A WHERE A.PROCESS_INSTANCE = 0 AND A.GRP_AP_STATUS = 'A' AND A.DTTM_ASSIGNED = ( SELECT MIN(I.DTTM_ASSIGNED) FROM PS_GRP_AP I WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.ASSIGNED_TO_OPRID = A.ASSIGNED_TO_OPRID AND I.GRP_AP_STATUS = A.GRP_AP_STATUS) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | GRP_AP_ID | Character(10) | VARCHAR2(10) NOT NULL | Control Group ID |