CNT_GROUPS_VW(SQL View) |
Index Back |
|---|---|
Contract Group View11/15/2015 JOHAN PO0025 - Master contract fluid |
| SELECT R.SETID , R.CNTRCT_ID_CHILD , R.CNTRCT_ID , R.VERSION_NBR , H.DESCR , H.CNTRCT_STATUS , H.CNTRCT_BEGIN_DT , H.CNTRCT_EXPIRE_DT , R.RELTN_STATUS , S.CNTRCT_STYLE_NAME FROM PS_CNTRCT_RELTN R , PS_CNTRCT_HDR H , PS_CNTRCT_STYLE S WHERE R.SETID = H.SETID AND R.CNTRCT_ID = H.CNTRCT_ID AND R.VERSION_NBR = H.VERSION_NBR AND H.VERSION_STATUS = 'C' AND S.CNTRCT_STYLE = H.CNTRCT_STYLE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 3 | CNTRCT_ID_GRP | Character(25) | VARCHAR2(25) NOT NULL | Contract ID To |
| 4 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | CNTRCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Status
A=Approved C=Closed H=On-Hold O=Open P=Pre-Approved X=Canceled |
| 7 | CNTRCT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 8 | CNTRCT_EXPIRE_DT | Date(10) | DATE | Expire Date |
| 9 | RELTN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Relationship Status
A=Active I=Inactive |
| 10 | CNTRCT_STYLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Style Description |