SAD_UC_I_AMEND(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_UC_APRDATE | DateTime(26) | TIMESTAMP | Date of Last Change of APR |
| 2 | SAD_UC_DISDATE | DateTime(26) | TIMESTAMP | Date of LastChange of cvRefDis |
| 3 | SAD_UC_ERRORDATE | DateTime(26) | TIMESTAMP | cvRefError Date of Last Change |
| 4 | SAD_UC_ETHNICDATE | DateTime(26) | TIMESTAMP | cvRefEthnic LastChanged Date |
| 5 | SAD_UC_EXAMDATE | DateTime(26) | TIMESTAMP | cvRefExam Last Changed Date |
| 6 | SAD_UC_FEEDATE | DateTime(26) | TIMESTAMP | cvRefFee Last Changed Date |
| 7 | SAD_UC_KEYWORDDATE | DateTime(26) | TIMESTAMP | cvRefKeyword LastChanged Date |
| 8 | SAD_UC_OEQDATE | DateTime(26) | TIMESTAMP | cvRefOEQ Last Changed Date |
| 9 | SAD_UC_OFFABBDATE | DateTime(26) | TIMESTAMP | cvRefOfferAbbrev LastChangedDt |
| 10 | SAD_UC_OFFSUBJDATE | DateTime(26) | TIMESTAMP | cvRefOfferSubj & cvRefSub Chg |
| 11 | SAD_UC_POCCDATE | DateTime(26) | TIMESTAMP | cvRefPOCC ast Changed Date |
| 12 | SAD_UC_RESCATDATE | DateTime(26) | TIMESTAMP | cvRefResCat Last Changed Date |
| 13 | SAD_UC_AWDBODYDATE | DateTime(26) | TIMESTAMP | cvRefAwardBody Last Changed |
| 14 | SAD_UC_STATUSDATE | DateTime(26) | TIMESTAMP | cvRefStatus Last Changed Date |
| 15 | SAD_UC_SCHTYPEDATE | DateTime(26) | TIMESTAMP | cvRefSchoolType LastChanged Dt |
| 16 | SAD_UC_SCHYEARDATE | DateTime(26) | TIMESTAMP | cvRefSchoolYear LastChanged Dt |
| 17 | SAD_UC_ESTGRPDATE | DateTime(26) | TIMESTAMP | cvRefEstGroup Last Changed Dat |
| 18 | SAD_UC_COUNTRYDATE | DateTime(26) | TIMESTAMP | cvRefCountry Last Changed Date |
| 19 | SAD_UC_CAREDATE | DateTime(26) | TIMESTAMP | cvRefCare Last Changed Date |
| 20 | SAD_UC_NATIONDATE | DateTime(26) | TIMESTAMP | cvNationality Last Changed Dt |
| 21 | SAD_UC_REGIONDATE | DateTime(26) | TIMESTAMP | cvnRefRegion Last Changed Date |
| 22 | SAD_UC_PARENTDATE | DateTime(26) | TIMESTAMP | cvRefParentinHE Last Changed |
| 23 | SAD_UC_SPONSORDATE | DateTime(26) | TIMESTAMP | cvRefPrepSponsor LastChanged |
| 24 | SAD_UC_CAREDURDATE | DateTime(26) | TIMESTAMP | Care Druation Date |
| 25 | SAD_UC_TARIFFDT | DateTime(26) | TIMESTAMP | Tariff Date |
| 26 | SAD_UC_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Action
A=Auto Declined D=Decline by Default R=Reject by Default U=Uprated |
| 27 | SAD_UC_LEADATE | DateTime(26) | TIMESTAMP | LEA Date |
| 28 | SAD_UC_POCC2010DT | DateTime(26) | TIMESTAMP | cvRefPOCC2010 last Changed Dat |
| 29 | SAD_UC_POCC2020DT | DateTime(26) | TIMESTAMP | cvRefPOCC2020 last change date |