EMPLIDDATE_LOADEDTAC_VCAL_CERT_YRTAC_VCAL_CERT_CDTAC_CERT_RES_STSAD_TAC_CD_VCL(SQL Table) |
Index Back |
|---|---|
VCAL Studies TAC SuspenseVCAL Studies TAC Suspense |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DATE_LOADED |
Date(10) | DATE | Date Loaded |
| 3 | TAC_VCAL_CERT_YR |
Character(4) | VARCHAR2(4) NOT NULL | VCAL Cert Year |
| 4 | TAC_VCAL_CERT_CD |
Character(15) | VARCHAR2(15) NOT NULL | VCAL Cert Code |
| 5 | TAC_CERT_RES_ST |
Character(1) | VARCHAR2(1) NOT NULL | TAC VCAL Result Status |