InvestorProgramNameType |
Base Entity | MI_REQUEST_DETAIL |
Attribute Name | InvestorProgramNameType |
Logical Rolename | |
ColumnName | InvestorProgramNameType |
RoleName | |
Domain | InvestorProgramNameEnum |
Definition | To identify loans originated for specific investor programs. |
Note |
InvestorProgramNameType Logical Attribute Properties |
Logical Attribute Name | InvestorProgramNameType |
Datatype | VARCHAR(0) |
Nullable | YES |
InvestorProgramNameType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InvestorProgramNameType Reference Value (Bound to Domain) |
Name | ValidationRule235 |
Description | |
Type | By List |
Value | Value Description |
Calpers | California Public Employees Retirement System |
Other | Other Investor Program name. |
PaymentPower | Loan program where qualified borrowers can skip up to 2 mortgage payments a year and 10 payments over the life of the loan. |
PrimeRatePlus | Loan program from Countrywide that relates to construction lending with ARM pricing. |
SettleAmerica | Loan program designed to qualify immigrant families for home loans. |
InvestorProgramNameType Bound Attachments |
Name | Current Value |
InvestorProgramNameType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InvestorProgramNameType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorProgramNameType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorProgramNameType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorProgramNameType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorProgramNameTypeOtherDescription |
Base Entity | MI_REQUEST_DETAIL |
Attribute Name | InvestorProgramNameTypeOtherDescription |
Logical Rolename | |
ColumnName | InvestorProgramNameTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | When Other is specified in Investor Program Name Type, this element contains the description. |
Note |
InvestorProgramNameTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | InvestorProgramNameTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
InvestorProgramNameTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InvestorProgramNameTypeOtherDescription Bound Attachments |
Name | Current Value |
InvestorProgramNameTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InvestorProgramNameTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorProgramNameTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorProgramNameTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorProgramNameTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameType |
Base Entity | MI_REQUEST_DETAIL |
Attribute Name | MICompanyNameType |
Logical Rolename | |
ColumnName | MICompanyNameType |
RoleName | |
Domain | MICompanyNameEnum |
Definition | To convey the private MI company short/common name from whom the private mortgage insurance coverage was obtained. |
Note |
MICompanyNameType Logical Attribute Properties |
Logical Attribute Name | MICompanyNameType |
Datatype | VARCHAR(0) |
Nullable | YES |
MICompanyNameType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICompanyNameType Reference Value (Bound to Domain) |
Name | ValidationRule282 |
Description | |
Type | By List |
Value | Value Description |
CMG | CMG |
Essent | Essent |
Genworth | Genworth |
MGIC | MGIC |
Other | Other |
PMI | PMI |
Radian | Radian |
RMIC | RMIC |
Triad | Triad |
UGI | UGI |
MICompanyNameType Bound Attachments |
Name | Current Value |
MICompanyNameType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICompanyNameType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameTypeOtherDescription |
Base Entity | MI_REQUEST_DETAIL |
Attribute Name | MICompanyNameTypeOtherDescription |
Logical Rolename | |
ColumnName | MICompanyNameTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to capture the mortgage insurance company name if Other is selected as the mortgage insurance company name. |
Note |
MICompanyNameTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MICompanyNameTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MICompanyNameTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICompanyNameTypeOtherDescription Bound Attachments |
Name | Current Value |
MICompanyNameTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICompanyNameTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIRequestType |
Base Entity | MI_REQUEST_DETAIL |
Attribute Name | MIRequestType |
Logical Rolename | |
ColumnName | MIRequestType |
RoleName | |
Domain | MIRequestEnum |
Definition | To distinguish an original request application for private mortgage insurance from any subsequent requests for the same loan, and from the MIs response to the order. |
Note |
MIRequestType Logical Attribute Properties |
Logical Attribute Name | MIRequestType |
Datatype | VARCHAR(0) |
Nullable | YES |
MIRequestType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIRequestType Reference Value (Bound to Domain) |
Name | ValidationRule296 |
Description | |
Type | By List |
Value | Value Description |
OriginalRequest | OriginalRequest |
Other | Other |
Resubmission | Used when making revisions or changes to an existing MI application. |
StatusQuery | StatusQuery |
MIRequestType Bound Attachments |
Name | Current Value |
MIRequestType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIRequestType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIRequestType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIRequestType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIRequestType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIRequestTypeOtherDescription |
Base Entity | MI_REQUEST_DETAIL |
Attribute Name | MIRequestTypeOtherDescription |
Logical Rolename | |
ColumnName | MIRequestTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to capture the description of the type of MI Request if Other is selected as the MIRequestType. |
Note |
MIRequestTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MIRequestTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MIRequestTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIRequestTypeOtherDescription Bound Attachments |
Name | Current Value |
MIRequestTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIRequestTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIRequestTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIRequestTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIRequestTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |