ERE_ID_ESPCOMPANYPrompt Table: COMPANY_TBL
Prompt Table: PERS_SRCH_GBL
0=No
1=Yes
Default Value: 0
Y/N Table Edit
1=Private Company
2=Public Administration
3=Other Public Sector
Default Value: 1
ERE_CMP_DTA_ESP(SQL Table) |
Index Back |
|---|---|
ERE Company dataERE Company data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERE_ID_ESP |
Character(10) | VARCHAR2(10) NOT NULL | ERE ID |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 3 | RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Responsible ID
Prompt Table: PERS_SRCH_GBL |
| 4 | PUBLISH_DT | Date(10) | DATE | Publish Date |
| 5 | LBR_SIGN_DT_ESP | Date(10) | DATE | Labor agreement sign date |
| 6 | ERE_CNTB_RESP_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Contribution response flag. Option to instruct SPEE to send contribution data back to the company.
0=No 1=Yes Default Value: 0 |
| 7 | ERE_CMP_W_PRFT_ESP | Character(1) | VARCHAR2(1) NOT NULL |
ERE Company with profits
Y/N Table Edit |
| 8 | ERE_DECISN_DT_ESP | Date(10) | DATE | ERE Company Decision Date |
| 9 | ERE_CMP_TYPE_ESP | Character(1) | VARCHAR2(1) NOT NULL |
ERE Company Legal Type
1=Private Company 2=Public Administration 3=Other Public Sector Default Value: 1 |
| 10 | ERE_PS_RPRT_DT_ESP | Date(10) | DATE | ERE Resolution Date |