EMPLIDDATE_ACQUIREDFT_SCHEDUC(SQL Table) |
Index Back |
|---|---|
Upgrade Only - Legacy BackupUpgrade Only - Legacy Backup This table holds a backup of Legacy Data created during the upgrade to Profile Management 9.0. When the customer is satisfied with the upgrade or no longer needs a copy of the prior data, this table should be dropped from the Database. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DATE_ACQUIRED |
Date(10) | DATE | Date Acquired |
| 3 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 4 | SCHOOL_TYPE | Character(3) | VARCHAR2(3) NOT NULL | School Type |
| 5 | EDUCATION_LVL_ACHV | Character(3) | VARCHAR2(3) NOT NULL | Education Level Achieved |
| 6 | COMPLETED | Character(1) | VARCHAR2(1) NOT NULL | Completed |
| 7 | SCHOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL | School Code |
| 8 | SCHOOL | Character(30) | VARCHAR2(30) NOT NULL | School Name |
| 9 | AVERAGE_GRADE | Character(5) | VARCHAR2(5) NOT NULL | Average Grade |
| 10 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 11 | JPM_PROFILE_ID | Character(12) | VARCHAR2(12) NOT NULL | The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile. |
| 12 | JPM_DISTINCT_IND | Character(1) | VARCHAR2(1) NOT NULL | Discinct Indicator |
| 13 | JPM_ITEM_KEY_ID | Number(12,0) | DECIMAL(12) NOT NULL | Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification. |
| 14 | FT_ALTERNATE_REC | Character(50) | VARCHAR2(50) NOT NULL | Source Record |
| 15 | FT_ALTERNATE_KEY | Character(254) | VARCHAR2(254) NOT NULL | Alternate Key |