Data Dictionary
Selected table: REVENUE
- Home
- Data Dictionary
- Table List
- REVENUE
id | Physical Name | Logical Name | Description | Category |
---|---|---|---|---|
1 | ENCTRSS_ID | NDW Encounter Record Identifier | This identifier is generated internally by the NDW and is used to uniquely identify an encounter record. | 100.0000 |
1 | EXPORT_ID | Export ID | Each export file that is received by the DW will be assigned a unique export ID number. This will allow us to track each record back to the "raw data file" if necessary. It also allows us to track certain information specific to each export such as number of records, date received, etc. | 100.0000 |
1 | REGION_ABBR_CD | Region Abbreviation Code | Alpha (3-char) designator indicating the IHS region (e.g. ALB for Albuquerque). | N/A |
1 | REVENUE_CD | Revenue Code | A subset of the HCPCS code set, 3 digit codes, indicating hospital charges. (Exception, dialysis codes are considered outpatient services) | N/A |
1 | REVENUE_COST_AMT | Revenue Cost Amount | Total cost for all occurrences of the associated revenue code in this encounter. | N/A |
1 | REVENUE_QTY | Revenue Quantity | Count of the number of times the associated revenue code was listed for this encounter. | N/A |
1 | SEQ_NBR | Sequence Number | For the first occurrence, the sequence number is 1; for the second occurrence, the sequence number is 2, and so on. | 100.0000 |