referralservices

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the referralservices table.

startdate VARCHAR
enddate VARCHAR
sequence INTEGER
units INTEGER
unitsused INTEGER
comment VARCHAR
servicecodeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

statusterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

referringcaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

providercaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

modifier1term_id INTEGER

Surrogate key. Foreign key reference to terms.id

modifier2term_id INTEGER

Surrogate key. Foreign key reference to terms.id

modifier3term_id INTEGER

Surrogate key. Foreign key reference to terms.id

modifier4term_id INTEGER

Surrogate key. Foreign key reference to terms.id

codetypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

referral_id VARCHAR

Surrogate key. Foreign key reference to referrals.id

inserteddate TIMESTAMP

Timestamp (UTC) indicating the date the row was first inserted into HIEBus.

insertedbyapplication_id SMALLINT

The application that first inserted the row into HIEBus. Foreign key reference to applications.id.

insertedbyuser_id VARCHAR

The user associated with the process that first inserted the row into HIEBus. Foreign key reference to users.id.

modifieddate TIMESTAMP

Timestamp (UTC) indicating the date the row was last modified.

modifiedbyapplication_id SMALLINT

The application that last modified the row. Foreign key reference to applications.id.

modifiedbyuser_id VARCHAR

The user associated with the process that last modified the row. Foreign key reference to users.id.

requestedstartdate VARCHAR
requestedenddate VARCHAR
authorizedstartdate VARCHAR
authorizedenddate VARCHAR
unitsrequested INTEGER
totalunitsrequested INTEGER
unitsapproved INTEGER
totalunitsapproved INTEGER
providercaregiverinnetwork VARCHAR
providercaregiverinnetworkoverridden VARCHAR
providerfacilityinnetwork VARCHAR
providerfacilityinnetworkoverridden VARCHAR
lateprecertpenalty VARCHAR
lateprecertpenaltywaved VARCHAR
approveddate VARCHAR
referringfacilitycaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

providerfacilitycaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

unittypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

requestedplaceofserviceterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

authorizedplaceofserviceterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

statusreasonterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

cost NUMERIC
frequencyterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id

providercaregiverinnetworkoverridereason VARCHAR
providerfacilityinnetworkoverridereason VARCHAR

Back to Tables