OPRIDSETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
CB_CONTRACT_IDDefault Value: NEXT
Prompt Table: CB_CON_SEC_VW
A=Approved
C=Cancelled
H=Hold
L=Closed
O=Open
Default Value: O
CB_CON_SEC_VW(SQL View) |
Index Back |
|---|---|
Claimback Contract Security |
| SELECT DISTINCT A.OPRID , B.SETID , B.CB_CONTRACT_ID , B.CB_STATUS , B.DESCR FROM PSOPRDEFN A , PS_CB_HDR B WHERE (A.OPRID = B.CB_MANAGER_ID) OR (A.OPRID IN ( SELECT C.CB_SECURITY_ID FROM PS_CB_UNRESTRICTED C WHERE C.CB_SECURITY_TYPE = 'U' AND C.SETID = B.SETID)) OR (A.OPRID IN ( SELECT D.ROLEUSER FROM PSROLEUSER D WHERE D.ROLENAME IN ( SELECT E.CB_SECURITY_ID FROM PS_CB_UNRESTRICTED E WHERE E.CB_SECURITY_TYPE = 'R' AND E.SETID = B.SETID))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 3 | CB_CONTRACT_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Claimback Contract ID
Default Value: NEXT Prompt Table: CB_CON_SEC_VW |
| 4 | CB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Claimback Contract Status
A=Approved C=Cancelled H=Hold L=Closed O=Open Default Value: O |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |