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 |