SCR_GVCT_HST

(SQL Table)
Index Back

SCR GovtClassification History

SCR Government Classifications Adjustment History

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCR_ID Character(15) VARCHAR2(15) NOT NULL Supplier Change Request ID
2 SCR_SEQ_NUM Number(5,0) INTEGER NOT NULL Update Sequence Number
3 CERTIF_SOURCE Character(10) VARCHAR2(10) NOT NULL Certification Source
4 GOV_CLASS Character(10) VARCHAR2(10) NOT NULL Government Classification
5 SEQNUM 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