3.2.6 Party Employment Details
Entity Name: EMPT
Description: This table holds party employment data product processor.
Data Sequence:
EMPT|Party Id|Employment Sequence Number|Employment Type|Employment Status|Employer Name|Industry Type|Company Type|Occupation|Designation|Gross Annual Salary|Start Date|End Date|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10|udf11|udf12|udf13|udf14|udf15|udf16|udf17|udf18|udf19|udf20|udf21|udf22|udf23|udf24|udf25|udf26|udf27|udf28|udf29|udf30|udf31|udf32|udf33|udf34|udf35|udf36|udf37|udf38|udf39|udf40|udf41|udf42|udf43|udf44|udf45|udf46|udf47|udf48|udf49|udf50
Table 3-12 Party Employment Details
Field Name | Description | Possible Values / Examples | Data Type | Data Length | Required/Optional |
---|---|---|---|---|---|
Party Id | Party Id as stored in Host | - | VARCHAR2 | 30 | Required |
Employment Sequence Number/Profile ID | Unique Profile Id of the Employment Record | - | VARCHAR2 | 40 | Required |
Employment Type | Employment Type |
SAL- Salaried SLF - Self Employed OTH - Others NAP - Not Applicable |
VARCHAR2 | 30 | Required |
Employment Status | Employment Status Code |
FTM - Full Time PTM - Part Time SLF - Self Employed STU - Student UNE - Unemployed RT- Retired CON - Contract HD - Home Duties |
VARCHAR2 | 30 | Required |
Employer Name | Name of the employer of the customer | - | VARCHAR2 | 120 | Optional |
Industry Type | - | - | VARCHAR2 | 30 | Optional |
Company Type | - |
E.g. a. Public Limited b. Private Limited c. Government Organization |
VARCHAR2 | 30 | Optional |
Occupation | - | - | VARCHAR2 | 30 | Optional |
Designation | - | - | VARCHAR2 | 120 | Optional |
Gross Annual Salary | - | - | NUMBER | 36 | Optional |
Start Date | Employment Start Date | - | DATE | - | Optional |
End Date | Employment End Date | - | DATE | - | Optional |
Parent topic: Party Data