EMPLIDPrompt Table: PERSONAL_DATA
EFFDTDefault Value: %date
Prompt Table: COMPANY_TBL
Prompt Table: XML_SSN_ESP_VW
XML_CTTA_VW(SQL View) |
Index Back |
|---|---|
View Contrat@ DataView Contrat@ Data |
| SELECT A.EMPLID , A.EFFDT , A.EMPL_RCD , A.EFFSEQ , A.COMPANY , A.SSN_EMPLOYER , A.CONTRACT_BEGIN_DT , A.CONTRACT_END_DT , %Substring(D.NATIONAL_ID,1,12) FROM PS_JOBDATA_ESP_VW A , PS_PERS_NID D WHERE A.EMPLID = D.EMPLID AND D.NATIONAL_ID_TYPE = 'SSN' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 6 | SSN_EMPLOYER | Character(13) | VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table: XML_SSN_ESP_VW |
| 7 | CONTRACT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 8 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 9 | CTTA_SSN_ESP | Character(12) | VARCHAR2(12) NOT NULL | SSN Contrata |