CONTRACT_NUMCA_CNTR_HDR_H_V(SQL View) |
Index Back |
|---|---|
CA Header History record ViewContract Header history record view for Search delete query. |
| SELECT A.CONTRACT_NUM , A.BUSINESS_UNIT , B.PSARCH_EVENTDTTM FROM PS_CA_CONTR_HDR_H A , PSARCHAUDIT B WHERE A.PSARCH_ID = B.PSARCH_ID AND A.PSARCH_BATCHNUM = B.PSARCH_BATCHNUM AND B.RECNAME = 'CA_CONTR_HDR' AND NOT EXISTS ( SELECT HDR.CONTRACT_NUM , HDR.BUSINESS_UNIT FROM PS_CA_CONTR_HDR HDR WHERE HDR.CONTRACT_NUM = A.CONTRACT_NUM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PSARCH_EVENTDTTM | DateTime(26) | TIMESTAMP | Event Date/Time |