SCR_GVCT_HST(SQL Table) |
Index Back |
|---|---|
SCR GovtClassification HistorySCR Government Classifications Adjustment History |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(15) | VARCHAR2(15) NOT NULL | Supplier Change Request ID | |
| 2 | Number(5,0) | INTEGER NOT NULL | Update Sequence Number | |
| 3 | Character(10) | VARCHAR2(10) NOT NULL | Certification Source | |
| 4 | Character(10) | VARCHAR2(10) NOT NULL | Government Classification | |
| 5 | Number(3,0) | SMALLINT NOT NULL | Sequence Number | |
| 6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | SCR_EFFDT | Date(10) | DATE | Approved Changes Take Effect |
| 8 | SCR_CHG_EFF_WHEN | Character(1) | VARCHAR2(1) NOT NULL |
Change Effective
I=Approval Date S=Future Date |
| 9 | GOV_CERTIF_NBR | Character(50) | VARCHAR2(50) NOT NULL | Certification Number |
| 10 | CERTIFICATE_EXP_DT | Date(10) | DATE | Certificate Expiration |
| 11 | CERTIFICATE_BEG_DT | Date(10) | DATE | Certificate Begin Date |
| 12 | SCR_CERTIF_SOURCE | Character(10) | VARCHAR2(10) NOT NULL | Certification Source |
| 13 | SCR_GOV_CLASS | Character(10) | VARCHAR2(10) NOT NULL | Government Classification |
| 14 | SCR_REMOVE | Character(1) | VARCHAR2(1) NOT NULL | Remove Contact |
| 15 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 16 | ENTERED_DTTM | DateTime(26) | TIMESTAMP | Entered Datetime |