Database Table: LiteAgencyReferral
Lite Agency Referral:
A Lite agency referral is created to refer a client to an external agency for a program offering.
Example For example, a client may have a referral created for them where a program offering is recommended from a particular external agency. |
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
|
|
Location in Model: | Logical View::MetaModel::Curam::LiteReferral::Entity::LiteAgencyReferral::LiteAgencyReferral |
Controlling File: | ReferralsLite\model\Packages\Entity\LiteReferral\LiteAgencyReferral\LiteAgencyReferral.efx |
ALLOW_OPTIMISTIC_LOCKING | yes |
Attribute | Stereotype | Nullable | Description | Domain Definition | Codetable | DDL Type |
liteReferralID | key | no | | INTERNAL_ID | | SVR_INT64 |
externalAgencyBranchOfferingID | details | yes | Note: A missing foreign key was created for this field in Curam 6.0 SP3. The Allow Nulls on this foreign key field was changed from 'Not Specified' to 'Yes' as this needs to be specifed on creation of the foreign key. However this should be 'No' but to prevent upgrade impact, the constraint could not be tightened from 'Not Specified' to 'No'. | INTERNAL_ID | | SVR_INT64 |
recordStatus | details | | | RECORD_STATUS_CODE | RecordStatus | SVR_STRING<10> |
|
Index Name | Attributes |
IND_1451355554 | externalAgencyBranchOfferingID |
|
Operation | Stereotype | Options | Description | SQL |
insert | insert | | Standard Operation | |
modify | modify | OPTIMISTIC_LOCKING: yes
| Standard Operation | |
read | read | | Standard Operation | |
remove | remove | | Standard Operation | |
|