ACTIVE_IND |
DOUBLE |
N |
The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ALLOW_FUTURE_IND |
DOUBLE |
N |
Allow future indicator (yes (1) or No (0)) |
ALLOW_HISTORIC_IND |
DOUBLE |
N |
Allow historic indicator (yes (1) or No (0)) |
ALLOW_PROCEDURE_LVL_IND |
DOUBLE |
N |
Allow Procedure level indicator (yes (1) or No (0)) |
ALLOW_SERVICE_TYPE_LVL_IND |
DOUBLE |
N |
Allow service type level indicator (yes (1) or No (0)) |
AUTOMATION_FLAG |
DOUBLE |
N |
The type of automation used. |
BEG_EFFECTIVE_DT_TM |
DATETIME |
N |
The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CONTACT |
VARCHAR(100) |
Y |
Contact. |
CONTRIBUTOR_SYSTEM_CD |
DOUBLE |
N |
Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DATA_DURATION |
DOUBLE |
N |
Duration, in number of seconds, in which data should remain available. |
DATA_DURATION_FLAG |
DOUBLE |
N |
The type of data duration. 0 - Message not returned, 1 - Message returned (eligible), 1 - Message returned (not eligible), 3 - Message returned (Unknown or non-eligibility message), 4 - Message returned (error), 5 - Message template. |
DEFAULT_SVC_TYPE_CD |
DOUBLE |
N |
The default service type. |
DEP_UNIQ_ID_CD |
DOUBLE |
N |
Indicates if this profile has dependents that are uniquely identifiable -No HL23 |
DESCRIPTION |
VARCHAR(100) |
Y |
Description of profile. |
END_EFFECTIVE_DT_TM |
DATETIME |
N |
The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
GS_APP_RECEIVERS_CODE |
VARCHAR(15) |
Y |
Data to be placed in the outbound field.. GS-03 |
GS_APP_SENDERS_CODE |
VARCHAR(15) |
Y |
Data to be placed in the outbound field.. GS-02 |
HEALTH_PLAN_ID |
DOUBLE |
N |
The ID of the health plan associated with the profile. |
INFOSOURCE_COMM_NUM1 |
VARCHAR(80) |
Y |
Requester's first communication number for contacting the requester. |
INFOSOURCE_COMM_NUM1_CD |
DOUBLE |
N |
Requester's first communication number qualifier code for the requester (email, fax, phone). |
INFOSOURCE_COMM_NUM2 |
VARCHAR(80) |
Y |
Requester's second communication number for contacting the requester. |
INFOSOURCE_COMM_NUM2_CD |
DOUBLE |
N |
Requester's second communication number qualifier code for the requester (email, fax, phone, extension). |
INFOSOURCE_COMM_NUM3 |
VARCHAR(80) |
Y |
Requester's third communication number for contacting the requester. |
INFOSOURCE_COMM_NUM3_CD |
DOUBLE |
N |
Requester's third communication number qualifier code for the requester (email, fax, phone, extension). |
INFOSOURCE_CONTACT_NAME |
VARCHAR(60) |
Y |
Requester's contact Name for the requester of the authorization transaction. |
INFOSOURCE_ENTITY_ID_CD |
DOUBLE |
N |
Data to be placed in the outbound field.. NM1-01. |
INFOSOURCE_ENTITY_TYPE_CD |
DOUBLE |
N |
Data to be placed in the outbound field.. NM1-02. |
INFOSOURCE_ID_CD |
DOUBLE |
N |
Data to be placed in the outbound field.. NM1-08. |
INFOSOURCE_NAME_FIRST |
VARCHAR(35) |
Y |
Data to be placed in the outbound field.. HL-20 -> NM1-04 (If NM1-02 has a "1"). |
INFOSOURCE_NAME_LAST_ORG |
VARCHAR(60) |
Y |
Data to be placed in the outbound field.. NM1-03. |
INFOSOURCE_NAME_MIDDLE |
VARCHAR(25) |
Y |
Data to be placed in the outbound field.. NM1-05. |
INFOSOURCE_NAME_SUFFIX |
VARCHAR(10) |
Y |
Data to be placed in the outbound field.. NM1-07. |
INFOSOURCE_PRIMARY_IDEN |
VARCHAR(80) |
Y |
Data to be placed in the outbound field.. NM1-09 (Qualified by NM1-08). |
INITIAL_DELAY |
DOUBLE |
N |
The number of seconds to wait before any polling should take place. |
ISA_ACK_REQUESTED_CD |
DOUBLE |
N |
Data to be placed in the outbound field.. ISA-14. |
ISA_AUTHOR_INFORMATION |
VARCHAR(10) |
Y |
Data to be placed in the outbound field.. ISA-02. |
ISA_AUTHOR_INFO_QUAL_CD |
DOUBLE |
N |
ISA-01 |
ISA_INTERCHG_REC_IDEN |
VARCHAR(15) |
Y |
Data to be placed in the outbound field.. ISA-08. |
ISA_INTERCHG_REC_ID_QUAL_CD |
DOUBLE |
N |
Data to be placed in the outbound field.. ISA-07. |
ISA_INTERCHG_SENDER_IDEN |
VARCHAR(15) |
Y |
Data to be placed in the outbound field. ISA-06. |
ISA_INTERCHG_SENDER_ID_QUAL_CD |
DOUBLE |
N |
Data to be placed in the outbound field.. ISA-05 |
ISA_SECURITY_INFORMATION |
VARCHAR(10) |
Y |
Data to be placed in the outbound field.. ISA-04. |
ISA_SECURITY_INFO_QUAL_CD |
DOUBLE |
N |
Data to be placed in the outbound field.ISA-03. |
MAX_DELAY |
DOUBLE |
N |
The maximum number of seconds to wait before timing out transactions. |
MAX_RESUBMIT_DURATION |
DOUBLE |
N |
The maximum re-submit duration defines the length of time after a transaction was first submitted and the last time the transaction service should attempt a resubmit if necessary. |
MOH_FACILITY |
VARCHAR(30) |
Y |
Ministry issues values for facility identification |
MOH_LOCAL_DEVICE |
VARCHAR(30) |
Y |
Identifies where the transaction came from a facility (e.g., Emergency Department |
MOH_LOCAL_USER |
VARCHAR(30) |
Y |
Contains the client's authorization ID. |
MOH_PROVIDER |
VARCHAR(30) |
Y |
Ministry issued values for provider identification. |
MOH_TRANSACTION |
VARCHAR(30) |
Y |
RPVR0500 followed by a space |
MOH_USER |
VARCHAR(30) |
Y |
Authorization issues by the ministry |
PASSWORD |
VARCHAR(40) |
Y |
Foreign system password. |
PAYOR_ID |
DOUBLE |
N |
Organization ID of payor. |
POLL_DELAY |
DOUBLE |
N |
Number of seconds to wait between polls. |
POLL_DURATION |
DOUBLE |
N |
Number of seconds an incomplete transaction is available for polling. |
PROFILE_ID |
DOUBLE |
N |
The primary ID of this table. |
PROXY_FLAG |
DOUBLE |
N |
Indicates whether data is proxy hosted. 0 - Not proxy hosted, 1 - Proxy hosted. |
RP_COMM_NUM1 |
VARCHAR(256) |
Y |
First communication number for contacting the requester. |
RP_COMM_NUM1_CD |
DOUBLE |
N |
First communication number qualifier code for the requester (email, fax, phone). |
RP_COMM_NUM2 |
VARCHAR(256) |
Y |
Second communication NUMBER FOR contacting the requester. |
RP_COMM_NUM2_CD |
DOUBLE |
N |
Second communication NUMBER qualifier code FOR the requester (email, fax, phone, extension). |
RP_COMM_NUM3 |
VARCHAR(256) |
Y |
Third communication NUMBER FOR contacting the requester. |
RP_COMM_NUM3_CD |
DOUBLE |
N |
Third communication NUMBER qualifier code FOR the requester (email, fax, phone, extension). |
RP_CONTACT_NAME |
VARCHAR(60) |
Y |
Contact Name for the requester of the authorization transaction. |
RP_N3_ADDR1 |
VARCHAR(55) |
Y |
N3 segment address 1 (2100B N3-01). |
RP_N3_ADDR2 |
VARCHAR(55) |
Y |
N3 segment address 2 (2100B N3-02). |
RP_N4_CITY |
VARCHAR(30) |
Y |
N4 segment city (2100B N4-01). |
RP_N4_COUNTRY_CODE |
VARCHAR(3) |
Y |
N4 segment country code (2100B N4-04). |
RP_N4_POSTAL_CODE |
VARCHAR(15) |
Y |
N4 segment postal code (2100B N4-03). |
RP_N4_STATE_PROV_CD |
DOUBLE |
N |
N4 segment state/provential code (2100B N4-02). |
RP_NM1_ENTITY_ID_CD |
DOUBLE |
N |
NM1-segment entity id code set (2100B NM1-01). |
RP_NM1_ENTITY_TYPE_QUAL_CD |
DOUBLE |
N |
NM1-segment entity type qual code set (2100B NM1-02). |
RP_NM1_IDEN |
VARCHAR(80) |
Y |
NM1 segment identification. |
RP_NM1_IDEN_CD |
DOUBLE |
N |
NM1 segment identification code value (2100B NM1-09). |
RP_NM1_NAME_FIRST |
VARCHAR(35) |
Y |
NM1 segment First Name (2100B NM1-04). |
RP_NM1_NAME_LAST_ORG |
VARCHAR(60) |
Y |
NM1 segment last or organization Name (2100B NM1-03). |
RP_NM1_NAME_MIDDLE |
VARCHAR(25) |
Y |
NM1 segment middle Name (2100B NM1-05). |
RP_NM1_NAME_SUFFIX |
VARCHAR(10) |
Y |
NM1 segment suffix (2100B NM1-07). |
RP_PRV_PROV_CD |
DOUBLE |
N |
PRV segment provider code value (2100B PRV-01). |
RP_PRV_REF_ID |
VARCHAR(50) |
Y |
PRV segment reference identification code value (2100B PRV-02). |
RP_PRV_REF_ID_QUAL_CD |
DOUBLE |
N |
PRV segment reference identification qual code value (2100B PRV-03). |
RP_REF_CARRIER_REF_NUM |
VARCHAR(50) |
Y |
The carrier assigned reference NUMBER IS additional reference identification FOR the TRANSACTION requester. |
RP_REF_CONTRACT_NUM |
VARCHAR(50) |
Y |
The REF segment contract number. |
RP_REF_CONTRACT_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment contract number. |
RP_REF_ELECT_DEV_PIN_NUM |
VARCHAR(50) |
Y |
The pin number REF electronic device. |
RP_REF_ELECT_DEV_PIN_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF electronic device pin number. |
RP_REF_EMPLOYER_ID_NUM |
VARCHAR(50) |
Y |
The employer id NUMBER IS additional reference identification FOR the TRANSACTION requester. |
RP_REF_FACILITY_ID_NUM |
VARCHAR(50) |
Y |
The number of the REF segment facility. |
RP_REF_FACILITY_ID_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment facility id number. |
RP_REF_FAC_NETWK_ID_NUM |
VARCHAR(50) |
Y |
The number of the REF segment facility network. |
RP_REF_FAC_NETWK_ID_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment facility network. |
RP_REF_FED_TAXPAYER_NUM |
VARCHAR(50) |
Y |
The federal taxpayer number of the REF segment. |
RP_REF_FED_TAXPAYER_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment federal taxpayer number. |
RP_REF_HCFA_NAT_PROV_NUM |
VARCHAR(50) |
Y |
The number of the REF segment HCFA national provider. |
RP_REF_HCFA_NAT_PROV_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment HCFA national provider number. |
RP_REF_MEDICAID_PRV_NUM |
VARCHAR(50) |
Y |
The number of the REF segment Medicaid provider. |
RP_REF_MEDICAID_PRV_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment Medicaid provider number. |
RP_REF_MEDICARE_PRV_NUM |
VARCHAR(50) |
Y |
The number of the REF segment Medicare provider. |
RP_REF_MEDICARE_PRV_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment Medicare provider number. |
RP_REF_PERS_ID_NUM |
VARCHAR(50) |
Y |
The ID of the REF segment personal. |
RP_REF_PERS_ID_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment personal identification number. |
RP_REF_PRIOR_ID_NUM |
VARCHAR(50) |
Y |
The ID of the REF segment prior. |
RP_REF_PRIOR_ID_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment prior number. |
RP_REF_PRV_PLN_NW_ID_NUM |
VARCHAR(50) |
Y |
The ID of the REF segment provider plan network. |
RP_REF_PRV_PLN_NW_ID_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment provider plan network identification number. |
RP_REF_PRV_SITE_NUM |
VARCHAR(50) |
Y |
The provider site number to be used in the REF segment within the Information Source loop. |
RP_REF_PRV_UPIN_NUM |
VARCHAR(50) |
Y |
The provider UPIN NUMBER IS additional reference identification FOR the TRANSACTION requester. |
RP_REF_SSN |
VARCHAR(50) |
Y |
The REF segment social security number. |
RP_REF_SSN_DESC |
VARCHAR(80) |
Y |
The REF segment social security number description. |
RP_REF_STATE_LIC_NUM |
VARCHAR(50) |
Y |
The REF segment State license number. |
RP_REF_STATE_LIC_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment State license number. |
RP_REF_SUBMITTER_ID_NUM |
VARCHAR(50) |
Y |
The ID of the REF segment submitter. |
RP_REF_SUBMITTER_ID_NUM_DESC |
VARCHAR(80) |
Y |
The description of the REF segment submitter ID number. |
RP_REF_USER_ID |
VARCHAR(50) |
Y |
The ID of the REF segment user. |
RP_REF_USER_ID_DESC |
VARCHAR(80) |
Y |
The description of the REF segment user ID. |
TRANSACTION_CD |
DOUBLE |
N |
The type of transaction supported by this profile. |
TRANS_TYPE_FLAG |
DOUBLE |
N |
The type of transaction. 0 - Single transaction submission only, 1 - Single or batch transaction submission. |
TRANS_VERSION_CD |
DOUBLE |
N |
A codified attribute to define the transaction version supported |
UPDT_APPLCTX |
DOUBLE |
N |
The application context number from the record info block. |
UPDT_CNT |
DOUBLE |
N |
Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM |
DATETIME |
N |
The date and time the row was last inserted or updated. |
UPDT_ID |
DOUBLE |
N |
The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK |
DOUBLE |
N |
The registered (assigned) task number for the process that inserted or updated the row. |
USERNAME |
VARCHAR(40) |
Y |
User name for foreign system. |