SETIDPrompt Table:
SP_SETID_NONVW
Set Control Field: SETID
PERSON_IDA=Active
I=Inactive
RD_CONSG_OPRVW(SQL View) |
Index Back |
|---|---|
RD_CONSG_OPRVWSELECT DISTINCT A.SETID , A.PERSON_ID , A.FIRST_NAME , A.LAST_NAME , A.BO_NAME_AC , A.CUST_ID , A.TITLE , A.CUST_STATUS , B.OPRID FROM PS_RD_CONS_G_VW A , PS_SEC_SETID_OPR B WHERE A.SETID = B.SETID |
| SELECT DISTINCT A.SETID , A.PERSON_ID , A.FIRST_NAME , A.LAST_NAME , A.BO_NAME_AC , A.CUST_ID , A.TITLE , A.CUST_STATUS , B.OPRID FROM PS_RD_CONS_G_VW A , PS_SEC_SETID_OPR B WHERE A.SETID = B.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table:
SP_SETID_NONVW
|
| 2 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 6 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 7 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
| 8 | CUST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Customer Status Indicator. BC.CUST_STATUS
A=Active I=Inactive |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |