SETCNTRLVALUEREC_GROUP_IDRECNAMEAR_BUSET_VW1(SQL View) |
Index Back |
|---|---|
Record for set control value |
| SELECT R.SETCNTRLVALUE ,R.REC_GROUP_ID ,R.RECNAME ,R.SETID FROM PS_SET_CNTRL_REC R , PS_BUS_UNIT_TBL_AR B WHERE R.RECNAME IN ('DISPUTE_TBL', 'PP_MET_TBL', 'CUSTOMER','AR_SPECIALIST','CR_ANALYST_TBL','TEAM_MEMBER_VW','COLLECTOR_TBL') AND R.SETCNTRLVALUE = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETCNTRLVALUE |
Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 2 | REC_GROUP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Record Group ID |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |