Table Descriptions (iii)
Table Descriptions (iii)
SQL> describe pat_fin_acct;
Name Null? Type
------------------------------- -------- ----
PAT_NUM NOT NULL NUMBER(9)
PAT_FIN_ENC_NUM NUMBER(3)
CARE_CLS_CD CHAR(1)
STATUS CHAR(1)
PREADMT_REGSTR_DT_TM DATE
BAD_DEBT_DT_TM DATE
HIST_DT_TM DATE
ACTIV_PAT_NUM NUMBER(9)
ACTIV_PAT_FIN_ENC_NUM NUMBER(3)
ACTIV_PAT_NAME CHAR(31)
GUAR_NUM NUMBER(9)
GUAR_RELTN_CD CHAR(2)
MARITAL_STATUS CHAR(1)
GEO_CD CHAR(6)
RELIG_CD CHAR(3)
COURTESY_CD CHAR(1)
SPECL_PROGRM_CD CHAR(2)
EMPLYMT_STATUS CHAR(1)
EMPLYR_NAME CHAR(25)
EMPLYR_EMP_NUM CHAR(11)
EMPLYR_ADDR CHAR(30)
EMPLYR_CITY_NAME CHAR(15)
EMPLYR_STATE_CD CHAR(2)
EMPLYR_ZIP_CD CHAR(9)
EMPLYR_PHONE_NUM CHAR(11)
EMPLYR_CNTCT_NAME CHAR(25)
NURS_STN_CD CHAR(4)
RM_NUM CHAR(4)
BED_CD CHAR(2)
CARE_SUBCLS_CD CHAR(1)
PRNCPL_PAYOR_CD CHAR(2)
AR_SUBCLS_CD CHAR(3)
BAD_DEBT_CLS_CD CHAR(3)
SERV_CD CHAR(3)
ADMT_PROV_NUM NUMBER(5)
ATND_PROV_NUM NUMBER(5)
REF_PROV_NUM NUMBER(5)
REF_PROV_NAME CHAR(25)
MAJ_DRG_CD NUMBER(3)
OUTLR_STATUS CHAR(1)
DRG_APPRV_STATUS CHAR(1)
GRPR_REVIEW_CD NUMBER(2)
FINAL_BILL_DRG_CD NUMBER(3)
MAJ_DIAG_CATGRY_NUM NUMBER(2)
PRNCPL_PROCDR_CD CHAR(5)
PRNCPL_PROCDR_DT DATE
PROCDR_PROV_NUM NUMBER(5)
PROCDR_PROV_NAME CHAR(25)
PRNCPL_DIAG_CD CHAR(6)
MAJ_COST_DIAG_CD CHAR(6)
PREADMT_DT_TM DATE
ADMT_DT_TM DATE
ADMT_DIAG_CD CHAR(6)
ADMT_DIAG_DESCR CHAR(70)
ADMT_CLS_CD CHAR(1)
ADMT_SOURCE_CD CHAR(1)
ADMT_USER_INITL CHAR(3)
DISCH_DT_TM DATE
ANTCPT_DISCH_DT_TM DATE
DISCH_DISP_CD CHAR(2)
DISCH_RELEASE_TXT CHAR(50)
PREV_NURS_STN_CD CHAR(4)
PREV_RM_NUM CHAR(4)
PREV_BED_CD CHAR(2)
PREV_CARE_SUBCLS_CD CHAR(1)
PREV_SERV_CD CHAR(3)
PREV_ATND_PROV_NUM NUMBER(5)
PREV_COND_CD CHAR(1)
PREV_TRNSFR_DT_TM DATE
PEND_TRNSFR_DT_TM DATE
PEND_TRNSFR_LOCTN_TXT CHAR(10)
TRNSFR_REASON_TXT CHAR(30)
TRNSFR_EFFCT_DT_TM DATE
OUTPAT_CARE_CLS_CD CHAR(1)
ACCDNT_DT_TM DATE
ACCDNT_LOCTN_CD CHAR(2)
LAST_OUTPAT_VISIT_DT_TM DATE
EMER_DEPT_ARRIV_MODE_CD CHAR(1)
EMER_DEPT_DISCH_DT_TM DATE
EMER_DEPT_DISP_CD CHAR(2)
EMER_DEPT_POLICE_NOTIFY_STATUS CHAR(1)
HEALTH_BOARD_NOTIFY_STATUS CHAR(1)
REGSTR_OTHER_TXT CHAR(60)
USER_FLD_TXT CHAR(100)
MED_REC_CHART_NUM CHAR(6)
MED_REC_CHART_LOCTN_CD CHAR(5)
MED_REC_CMNT_TXT CHAR(30)
BLOOD_PROGRM_STATUS CHAR(1)
BLOOD_FURN_CNT NUMBER(2)
BLOOD_REPLACE_CNT NUMBER(2)
BLOOD_ORGNZTN_NAME CHAR(8)
UB82_LOCTR_02 CHAR(30)
UB82_LOCTR_09 CHAR(7)
UB82_LOCTR_27 CHAR(8)
UB82_LOCTR_45 CHAR(17)
OCCUR_SPAN_CD CHAR(2)
OCCUR_BEGIN_DT DATE
OCCUR_END_DT DATE
TOTL_GROSS_CHRG_AMT NUMBER(9,2)
LATE_ACTIV_AMT NUMBER(9,2)
LATE_ACTIV_ADJST_AMT NUMBER(9,2)
LAST_PAT_CYCLE_BILL_DT_TM DATE
LAST_INS_CYCLE_BILL_DT_TM DATE
FINAL_BILL_DT_TM DATE
LAST_ACTIV_DT_TM DATE
REBILL_STATUS CHAR(1)
LAST_PRORAT_DT_TM DATE
LAST_POST_DT_TM DATE
BAD_DEBT_WRITE_OFF_AMT NUMBER(9,2)
BAD_DEBT_WRITE_OFF_RECOVER_AMT NUMBER(9,2)
ACCT_REPRSNT_CD CHAR(3)
DIRECT_AR_STATUS CHAR(1)
LAST_STMT_DT_TM DATE
STMT_SENT_CNT NUMBER(2)
STMT_THREAT_CD NUMBER(2)
RECLS_SUPPRESS_STATUS CHAR(1)
FIRST_STMT_STATUS CHAR(1)
FIRST_STMT_DAY_CNT NUMBER(3)
OTHER_STMT_STATUS CHAR(1)
OTHER_STMT_DAY_CD NUMBER(3)
STMT_SMALL_BAL_STATUS CHAR(1)
STMT_FORM_CLS_CD CHAR(1)
STMT_MSG_SUPPRESS_STATUS CHAR(1)
GUAR_CNTRCT_CTRL_NUM NUMBER(9)
GUAR_CNTRCT_NUM NUMBER(3)
CONVR_STATUS CHAR(1)
CYCLE_UPDT_DT_TM DATE
MED_REC_UPDT_STATUS CHAR(1)
FACIL_TRNSFR_FROM_CD CHAR(5)
FACIL_TRNSFR_TO_CD CHAR(5)
UPDT_USER_INITL CHAR(3)
UPDT_DEPT_CD CHAR(3)
UPDT_DT_TM DATE