EMPLOYMENT |
EntityType | Dependent |
Logical Entity Name | EMPLOYMENT |
Default Table Name | DEAL/SERVICES/SERVICE/CREDIT/CREDIT_RESPONSE/PARTIES/PARTY/ROLES/ROLE/BORROWER/EMPLOYERS/EMPLOYER/EMPLOYMENT |
Definition | |
Note |
EMPLOYMENT Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
EmployedAbroadIndicator | MISMOIndicator | BIT | NO | Indicates if the physical place of employment of the borrower is located outside of the United States. If the employer of the borrower is a foreign entity and the place of employment of the borrower is located inside the United States this value would b |
EmploymentBorrowerHomeOfficeIndicator | MISMOIndicator | BIT | NO | Indicates that in the referenced employment, the office of the borrower is within the primary residence. |
EmploymentBorrowerSelfEmployedIndicator | MISMOIndicator | BIT | NO | Indicates that in the referenced employment the borrower is self-employed. |
EmploymentClassificationType | EmploymentClassificationEnum | VARCHAR(0) | YES | Indicates whether the employment for the borrower is primary or secondary. |
EmploymentEndDate | MISMODate | DATE | NO | The date that the borrower ended the employment position with the employer. Current employment would have no end data. One source of this data is the URLA in Section IV (Dated To). |
EmploymentMonthlyIncomeAmount | MISMOAmount | DECIMAL(0, 2) | NO | The dollar amount per month of Income associated with the borrowers employment. Note: For current secondary or previous primary or previous secondary income. |
EmploymentMonthsOnJobCount | MISMOCount | INTEGER | NO | The number of complete months of service to an employer from the start of employment until the date on which the employment is reported. |
EmploymentPositionDescription | MISMOString | VARCHAR(0) | NO | An expanded description of the borrowers employment position. Collected on the URLA in Section IV. |
EmploymentReportedDate | MISMODate | DATE | NO | Indicates the date when the employment information was reported to the repository bureau. |
EmploymentStartDate | MISMODate | DATE | NO | The date that the borrower started the employment position with the employer. |
EmploymentStatusType | EmploymentStatusEnum | VARCHAR(0) | YES | Indicates whether the employment for the borrower is current or previous. |
EmploymentTimeInLineOfWorkMonthsCount | MISMOCount | INTEGER | NO | The number of complete months the borrower has been employed in the reported occupation. |
EmploymentTimeInLineOfWorkYearsCount | MISMOCount | INTEGER | NO | The total number of years the borrower has been employed in thet reported occupation. One source of this data is the URLA Section IV (Years Employed In This Line Of Work.) |
EmploymentYearsOnJobCount | MISMOCount | INTEGER | NO | The number of complete years of service to an employer from the start of employment until the date on which the employment is reported. |
SpecialBorrowerEmployerRelationshipType | SpecialBorrowerEmployerRelationshipEnum | VARCHAR(0) | YES | Specifies a unique category of employer which is the source of income for the borrower. |
SpecialBorrowerEmployerRelationshipTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free form text field used to collect additional information when Other is selected for Borrower Employer Relationship Type. |
EMPLOYMENT Keys |
Key Name | Key Type | Keys |
EMPLOYMENT Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
EMPLOYER | Identifying | One to Zero or One | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
EMPLOYMENT Check Constraints |
Check Constraint Name | CheckConstraint |
EMPLOYMENT Bound Attachments |
Name | Current Value |
EMPLOYMENT User-Defined Mappings |
Model | Name | Description |
EMPLOYMENT Data Movement Rules |
Name | Type | Rule Text/Value |