AUTOPOPIDACCOMPLISHMENTDT_ISSUEDMAJOR_CODEHRS_AP_EDU_TMP(SQL Table) |
Index Back |
|---|---|
Auto Populate - EducationAuto Populate temporary table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AUTOPOPID |
Number(6,0) | INTEGER NOT NULL | Auto Populate unique ID |
| 2 | ACCOMPLISHMENT |
Character(8) | VARCHAR2(8) NOT NULL | Accomplishment |
| 3 | DT_ISSUED |
Date(10) | DATE | Issue Date |
| 4 | MAJOR_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Major Code |
| 5 | MAJOR | Character(30) | VARCHAR2(30) NOT NULL | Major |
| 6 | SCHOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL | School Code |
| 7 | SCHOOL | Character(30) | VARCHAR2(30) NOT NULL | School Name |
| 8 | STATE_OTHER | Character(6) | VARCHAR2(6) NOT NULL | State Other |
| 9 | COUNTRY_OTHER | Character(3) | VARCHAR2(3) NOT NULL | Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT |
| 10 | ACCOMPLISHMENT_TXT | Character(30) | VARCHAR2(30) NOT NULL | Accomplishment Text |