| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 3 |
SOCS_ER_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Employer
2=Collective
4=Public Administration
Default Value: 2
|
| 4 |
SOCS_ER_CODE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Employer
9=Fiscal Identification Code
Default Value: 9
|
| 5 |
FISCAL_ID_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Fiscal Identification Code
Default Value: COMPANY_TBL.FISCAL_ID_CD
|
| 6 |
SOCS_CNTRY_CD_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Social Security Country Code
Default Value: 00
Prompt Table:
SOCS_CTRY_ESPVW
|
| 7 |
SOCS_PROCS_CD_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Deliver Process Code
SM01=Magnetic Device
VIP3=MS DOS Suite
WST2=Winsuite
|
| 8 |
SOCS_AUTH_KEY_ESP |
Character(8) |
VARCHAR2(8) NOT NULL |
Authorization Key
|
| 9 |
SOCS_SILCON_ESP |
Character(8) |
VARCHAR2(8) NOT NULL |
Silcon Key
|
| 10 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON_NAME
|
| 11 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Contact Name
|
| 12 |
GPES_CONTACT_PHONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Contact phone number
|
| 13 |
GPES_CONTACT_FAX |
Character(9) |
VARCHAR2(9) NOT NULL |
Contact fax number
|
| 14 |
SRC_BANK_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table:
SRC_BANK
|
| 15 |
GPES_HOLDER_NAME |
Character(31) |
VARCHAR2(31) NOT NULL |
Holder name
|
| 16 |
DLT_PREVENTIVA_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Preventive
A=Business Owner
E=External
I=Internal
M=Shared
N=None
W=Designed Workers
|
| 17 |
MAX_NUM_ROWS_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Max rows displayed in a scroll
|
| 18 |
HOLDER_NAME_ESP |
Character(31) |
VARCHAR2(31) NOT NULL |
Holder name
|
| 19 |
CONTACT_PHONE_ESP |
Character(9) |
VARCHAR2(9) NOT NULL |
Contact phone number
|
| 20 |
CONTACT_FAX_ESP |
Character(9) |
VARCHAR2(9) NOT NULL |
Contact fax number
|
| 21 |
SRC_BANK_ID_2_ESP |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID 2. Used for special accounts numbers, for instance, negative liquid accounts.
Prompt Table:
SRC_BANK
|
| 22 |
HOLDER_NAME_2_ESP |
Character(31) |
VARCHAR2(31) NOT NULL |
Holder name for other uses.
Used for Special Accounts: Negative Liquid.
|
| 23 |
SOCS_PAY_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment
0=Cash
C=Direct Debit
V=Electronic Payment
|
| 24 |
SSN_MAIN_ESP |
Character(13) |
VARCHAR2(13) NOT NULL |
Main Ssn Employer
Prompt Table:
SOCS_CCC_ESP_VW
|
| 25 |
TRN_T_SSN_RDNT_ESP |
Character(13) |
VARCHAR2(13) NOT NULL |
Tripartita Foundation: SSN Employer to Report FT Reductions
Prompt Table:
SOCS_CCC_ESP_VW
|
| 26 |
STAFF_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Company Staff Type based on Staff Number:
P -> Small Company (<50 employees)
M -> Medium Company (<250 employees)
G -> Large Company (>=250 employees)
G=Large Company
M=Medium Company
P=Small Company
Default Value: M
|