PROC_GRP_IDRUN_CNTL_IDEO_AUD_DTL2_VW(SQL View) |
Index Back |
|---|---|
CCU Search Rec for Audit InqThe Currency Conversion Utility search record for the Audit Inquiry panel (page). |
| SELECT A.PROC_GRP_ID , B.RUN_CNTL_ID , C.PROC_GRP_NAME FROM PS_RUN_CNTL_CC3_EO A , PS_RUN_CNTL_AUD_EO B , PS_EO_PROC_GROUP C WHERE A.RUN_CNTL_ID = B.RUN_CNTL_ID AND A.PROC_GRP_ID = C.PROC_GRP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROC_GRP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Uniquely identifies a Currency Conversion Process Group |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PROC_GRP_NAME | Character(20) | VARCHAR2(20) NOT NULL | Process Group Name |