EMPLIDEMPL_RCDEFFDTEFFSEQLANGUAGE_CDGVT_EMPLOY_LANG(SQL Table) |
Index Back |
|---|---|
EE General Employment DataEMPLOYMENT is one of the core records in the database. Use it to record an employee's employment-related data that doesn't tend to change, such as hire date, termination date, and company service date. Many changes have been made for the US Federal Government. Related Language record for GVT_EMPLOYMENT. |
| # | 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 | BENEFIT_RCD_NBR | Number(3,0) | SMALLINT NOT NULL | Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number. |
| 7 | BUSINESS_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Business Title |