EMPLIDEMPL_RCDEFFDTEFFSEQLANGUAGE_CDGVT_PERS_LANG(SQL Table) |
Index Back |
|---|---|
GVT Personal DataPERSONAL_DATA is one of the core records in the database. Use it to record personal and demographic data about an employee or applicant including name, address, birthdate, and ethnic group. You can create only one PERSONAL_DATA record per person. Related Language record for GVT_PERS_DATA. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | BUSINESS_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Business Title |
| 7 | EMPLOYER | Character(30) | VARCHAR2(30) NOT NULL | Employer |
| 8 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 9 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |