SequenceNumber |
Base Entity | MILITARY_SERVICE |
Attribute Name | SequenceNumber |
Logical Rolename | |
ColumnName | SequenceNumber |
RoleName | |
Domain | XSD:Integer |
Definition | An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. |
Note |
SequenceNumber Logical Attribute Properties |
Logical Attribute Name | SequenceNumber |
Datatype | INTEGER |
Nullable | YES |
SequenceNumber Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SequenceNumber Bound Attachments |
Name | Current Value |
SequenceNumber User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SequenceNumber Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryBranchType |
Base Entity | MILITARY_SERVICE |
Attribute Name | MilitaryBranchType |
Logical Rolename | |
ColumnName | MilitaryBranchType |
RoleName | |
Domain | MilitaryBranchEnum |
Definition | Specifies the branch of service to which the VA borrower belongs. |
Note |
MilitaryBranchType Logical Attribute Properties |
Logical Attribute Name | MilitaryBranchType |
Datatype | VARCHAR(0) |
Nullable | YES |
MilitaryBranchType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MilitaryBranchType Reference Value (Bound to Domain) |
Name | ValidationRule313 |
Description | |
Type | By List |
Value | Value Description |
AirForce | AirForce |
AirNationalGuard | AirNationalGuard |
Army | Army |
ArmyNationalGuard | ArmyNationalGuard |
ArmyReserves | ArmyReserves |
CoastGuard | CoastGuard |
Marines | Marines |
MarinesReserves | MarinesReserves |
Navy | Navy |
NavyReserves | NavyReserves |
Other | Other |
MilitaryBranchType Bound Attachments |
Name | Current Value |
MilitaryBranchType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MilitaryBranchType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryBranchType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryBranchType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryBranchType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryBranchTypeOtherDescription |
Base Entity | MILITARY_SERVICE |
Attribute Name | MilitaryBranchTypeOtherDescription |
Logical Rolename | |
ColumnName | MilitaryBranchTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field which contains the description of the branch of the military to which the VA borrower belongs when Other is selected as the Military Branch Type. |
Note |
MilitaryBranchTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MilitaryBranchTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MilitaryBranchTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MilitaryBranchTypeOtherDescription Bound Attachments |
Name | Current Value |
MilitaryBranchTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MilitaryBranchTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryBranchTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryBranchTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryBranchTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceFromDate |
Base Entity | MILITARY_SERVICE |
Attribute Name | MilitaryServiceFromDate |
Logical Rolename | |
ColumnName | MilitaryServiceFromDate |
RoleName | |
Domain | MISMODate |
Definition | The date this period of service began. |
Note |
MilitaryServiceFromDate Logical Attribute Properties |
Logical Attribute Name | MilitaryServiceFromDate |
Datatype | DATE |
Nullable | NO |
MilitaryServiceFromDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MilitaryServiceFromDate Bound Attachments |
Name | Current Value |
MilitaryServiceFromDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MilitaryServiceFromDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceFromDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceFromDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceFromDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceNumberIdentifier |
Base Entity | MILITARY_SERVICE |
Attribute Name | MilitaryServiceNumberIdentifier |
Logical Rolename | |
ColumnName | MilitaryServiceNumberIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | VA military service identification number of the borrower. |
Note |
MilitaryServiceNumberIdentifier Logical Attribute Properties |
Logical Attribute Name | MilitaryServiceNumberIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
MilitaryServiceNumberIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MilitaryServiceNumberIdentifier Bound Attachments |
Name | Current Value |
MilitaryServiceNumberIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MilitaryServiceNumberIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceNumberIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceNumberIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceNumberIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceServedAsName |
Base Entity | MILITARY_SERVICE |
Attribute Name | MilitaryServiceServedAsName |
Logical Rolename | |
ColumnName | MilitaryServiceServedAsName |
RoleName | |
Domain | MISMOString |
Definition | Name of veteran exactly as it appears on separation papers of Statement of Service. |
Note |
MilitaryServiceServedAsName Logical Attribute Properties |
Logical Attribute Name | MilitaryServiceServedAsName |
Datatype | VARCHAR(0) |
Nullable | NO |
MilitaryServiceServedAsName Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MilitaryServiceServedAsName Bound Attachments |
Name | Current Value |
MilitaryServiceServedAsName User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MilitaryServiceServedAsName Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceServedAsName Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceServedAsName Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceServedAsName Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceToDate |
Base Entity | MILITARY_SERVICE |
Attribute Name | MilitaryServiceToDate |
Logical Rolename | |
ColumnName | MilitaryServiceToDate |
RoleName | |
Domain | MISMODate |
Definition | The date this period of service ended. |
Note |
MilitaryServiceToDate Logical Attribute Properties |
Logical Attribute Name | MilitaryServiceToDate |
Datatype | DATE |
Nullable | NO |
MilitaryServiceToDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MilitaryServiceToDate Bound Attachments |
Name | Current Value |
MilitaryServiceToDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MilitaryServiceToDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceToDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceToDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryServiceToDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryStatusType |
Base Entity | MILITARY_SERVICE |
Attribute Name | MilitaryStatusType |
Logical Rolename | |
ColumnName | MilitaryStatusType |
RoleName | |
Domain | MilitaryStatusEnum |
Definition | Specifies the current military status of the VA borrower. |
Note |
MilitaryStatusType Logical Attribute Properties |
Logical Attribute Name | MilitaryStatusType |
Datatype | VARCHAR(0) |
Nullable | YES |
MilitaryStatusType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MilitaryStatusType Reference Value (Bound to Domain) |
Name | ValidationRule314 |
Description | |
Type | By List |
Value | Value Description |
ActiveDuty | ActiveDuty |
Other | Other |
ReserveNationalGuardNotSubjectToActivation | ReserveNationalGuardNotSubjectToActivation |
Separated | Separated |
MilitaryStatusType Bound Attachments |
Name | Current Value |
MilitaryStatusType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MilitaryStatusType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryStatusType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryStatusType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryStatusType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryStatusTypeOtherDescription |
Base Entity | MILITARY_SERVICE |
Attribute Name | MilitaryStatusTypeOtherDescription |
Logical Rolename | |
ColumnName | MilitaryStatusTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field which contains the military status type of the VA when Other is selected as the Military Status Type. |
Note |
MilitaryStatusTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MilitaryStatusTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MilitaryStatusTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MilitaryStatusTypeOtherDescription Bound Attachments |
Name | Current Value |
MilitaryStatusTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MilitaryStatusTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryStatusTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryStatusTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MilitaryStatusTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
VADisabilityBenefitClaimIndicator |
Base Entity | MILITARY_SERVICE |
Attribute Name | VADisabilityBenefitClaimIndicator |
Logical Rolename | |
ColumnName | VADisabilityBenefitClaimIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | When true, indicates the borrower has filed a claim for VA disability benefits prior to discharge from active duty service. |
Note |
VADisabilityBenefitClaimIndicator Logical Attribute Properties |
Logical Attribute Name | VADisabilityBenefitClaimIndicator |
Datatype | BIT |
Nullable | NO |
VADisabilityBenefitClaimIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
VADisabilityBenefitClaimIndicator Bound Attachments |
Name | Current Value |
VADisabilityBenefitClaimIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
VADisabilityBenefitClaimIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
VADisabilityBenefitClaimIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
VADisabilityBenefitClaimIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
VADisabilityBenefitClaimIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
VAEligibilityIndicator |
Base Entity | MILITARY_SERVICE |
Attribute Name | VAEligibilityIndicator |
Logical Rolename | |
ColumnName | VAEligibilityIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | When true, indicates that this instance of military service is used to determine VA eligibility. NOTE: Only one instance of this container/element should have this set to true. |
Note |
VAEligibilityIndicator Logical Attribute Properties |
Logical Attribute Name | VAEligibilityIndicator |
Datatype | BIT |
Nullable | NO |
VAEligibilityIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
VAEligibilityIndicator Bound Attachments |
Name | Current Value |
VAEligibilityIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
VAEligibilityIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
VAEligibilityIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
VAEligibilityIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
VAEligibilityIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |