Skip to main content

Admit Source

Maintenance Instructions

  1. Navigate to the ResDac Inpatient website
  2. Click "View Data Documentation" under the page title
  3. Locate and select the Variable Name "Claim Source Inpatient Admission Code"
  4. Open the .txt file at the bottom of the webpage

Follow steps 5-11 if there are any changes to the admit source codes. Otherwise, skip to step 12

  1. Copy and paste the code list into any text editor
  2. Format the codes as a CSV file and save
    • Find and replace "—" with a hyphen (-)
  3. Import the CSV file into any data warehouse
  4. Upload the CSV file from the data warehouse to S3 (credentials with write permissions to the S3 bucket are required)
-- example code for Snowflake
copy into s3://tuva-public-resources/terminology/admit_source.csv
from [table_created_in_step_7]
file_format = (type = csv field_optionally_enclosed_by = '"')
storage_integration = [integration_with_s3_write_permissions]
OVERWRITE = TRUE;
  1. Create a branch in The Tuva Project
  2. Copy and paste the updated codes into the admit source file
  3. Submit a pull request
  4. Create a branch in docs. Update the last_updated column in the table above with the current date.
  5. Submit a pull request