Table Description

Veteran/Military Service: This evidence captures details about a Household Member's period of service in the military.

Veteran Military Service evidence describes a Household Member who is a veteran, an active duty military member, or a spouse or dependent child of a veteran/active duty member.

A veteran is a person who served in active military, naval or air service of the United States, and who has been discharged or released from there under conditions that are not dishonorable. Active duty in the armed forces of the United States means being on full-time duty in the U.S. army, navy, air force, marine corps, or coast guard.

If the Household Member is a spouse or dependent child of a veteran/active duty member, a veteran military record is created for the spouse or child and the veteran military details used are those of the veteran/active duty member.

Example

John Smith is in active military service as a major in the air force. John Smith is married to Linda Smith. So a case worker creates a Veteran Military Service record for Linda Smith with her veteran status as spouse of an active military member. The veteran/military details recorded on her record are those of her husband.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Household::VeteranMilitaryService::VetMilitaryServ
Controlling File: Evidence\model\ServiceLayer\entity\Household\VeteranMilitaryService\VeteranMilitaryService_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for a Veteran Military Service. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member for whom the details are being recorded. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
vetCaseParticipantRoleIDdetails 

The Case Participant Role ID of the veteran. This is entered if and only if the veteran is not a member of the household. The UI field name for this attribute is 'Military Veteran Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
branchOfServicedetails 

The branch in which the Household Member served. This is populated from the 'ServiceBranch' code table. Examples include: Army, Air Force, etc. The UI field name for this attribute is 'Branch Of Service'.

EVD_BRANCH_OF_SERVICEBranchOfServiceSVR_STRING<10>
militaryRankdetails 

The Household Members military rank. Examples include: Captain, Colonel, etc. This is populated from the 'MilitaryRank' code table. The UI field name for this attribute is 'Military Rank

EVD_MILITARY_RANKMilitaryRankSVR_STRING<10>
dateEnteredServicedetails 

The date on which the Household Member entered the service. The UI field name for this attribute is 'Date Entered Service'.

CURAM_DATE SVR_DATE
dateLeftServicedetails 

The date on which the Household Member left the service. The UI field name for this attribute is 'Date Left Service'.

CURAM_DATE SVR_DATE
veteranClaimNumberdetails 

The veteran's claim number. The UI field name for this attribute is 'Veteran Claim Number'.

EVD_VETERAN_CLAIM_NUMBER SVR_STRING<30>
commentsdetails 

Additional details related to the Veteran Military Service. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
VetMilitaryServ.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
searchDupVetMSrdxcaseParticipantRoleID, dateEnteredService, dateLeftService
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
readCaseParticipantsByEvidenceIDnsread Returns all related caseParticipantRoleID's for a specified Veteran Military Service ID. 
Related Pages (13)