OPRIDA=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled
OPR_DEF_CNTR_VW(SQL View) |
Index Back |
|---|---|
Opr Dflt Contract SettingsOpr Dflt Contract Settings |
| SELECT OPRID ,CNTRCT_ENTRY ,CNTRCT_APPROVE ,CNTRCT_HOLD , CNTRCT_CLOSE , CNTRCT_CANCEL ,CNTRCT_STATUS FROM PS_OPR_DEF_TBL_PM |
| # | 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 | CNTRCT_ENTRY | Character(1) | VARCHAR2(1) NOT NULL | Enter Contracts |
| 3 | CNTRCT_APPROVE | Character(1) | VARCHAR2(1) NOT NULL | Change Approve |
| 4 | CNTRCT_HOLD | Character(1) | VARCHAR2(1) NOT NULL | Hold Contracts |
| 5 | CNTRCT_CLOSE | Character(1) | VARCHAR2(1) NOT NULL | Close Contracts |
| 6 | CNTRCT_CANCEL | Character(1) | VARCHAR2(1) NOT NULL | Procurement Contract cancel authorization |
| 7 | CNTRCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Status
A=Approved C=Closed H=On-Hold O=Open P=Pre-Approved X=Canceled |