_8.patients_authorization_numbers

Field	Type	Null	Default	Key	Extra	Comment
pan_id	int(11)	NO		PRI	auto_increment
pan_cus_id	int(11)	NO		MUL
pan_cli_id	int(11)	NO		MUL
pan_pat_id	int(11)	NO		MUL
pan_date_begin	varchar(8)	NO		MUL
pan_date_end	varchar(8)	NO		MUL
pan_authorization_num	varchar(60)	NO
pan_irep_id	int(11)	NO	0	MUL		Insurance repository record (optional)
pan_cs_id	int(11)	NO	0	MUL		Code system if code provided
pan_code_id	bigint(20)	NO	0	MUL		Code ID if code provided
pan_code	varchar(45)	NO		MUL
pan_note	text	NO
pan_num_visits	varchar(11)	NO
pan_num_initial	int(11)	NO	0			Initial value of visits/units
pan_disabled	char(1)	NO
pan_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
pan_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

pan_id

Table	Column
_1.encounters	enc_ins2_pan_id
_1.encounters	enc_ins3_pan_id
_1.encounters	enc_ins1_pan_id
_1.encounters	enc_pan_id
_1.encounters_cpt_codes	ecp_ins2_pan_id
_1.encounters_cpt_codes	ecp_ins3_pan_id
_1.encounters_cpt_codes	ecp_pan_id
_1188.encounters	enc_ins1_pan_id
_1188.encounters	enc_ins2_pan_id
_1188.encounters	enc_ins3_pan_id
_1188.encounters_cpt_codes	ecp_pan_id
_1188.encounters_cpt_codes	ecp_ins2_pan_id
_1188.encounters_cpt_codes	ecp_ins3_pan_id
_1218.encounters	enc_ins1_pan_id
_1218.encounters	enc_ins2_pan_id
_1218.encounters	enc_ins3_pan_id
_1218.encounters_cpt_codes	ecp_pan_id
_1218.encounters_cpt_codes	ecp_ins2_pan_id
_1218.encounters_cpt_codes	ecp_ins3_pan_id
_1548.encounters	enc_ins2_pan_id
_1548.encounters	enc_ins3_pan_id
_1548.encounters	enc_ins1_pan_id
_1548.encounters	enc_pan_id
_1548.encounters_cpt_codes	ecp_ins2_pan_id
_1548.encounters_cpt_codes	ecp_ins3_pan_id
_1548.encounters_cpt_codes	ecp_pan_id
_435.encounters	enc_ins1_pan_id
_435.encounters	enc_pan_id
_435.encounters	enc_ins2_pan_id
_435.encounters	enc_ins3_pan_id
_435.encounters_cpt_codes	ecp_pan_id
_435.encounters_cpt_codes	ecp_ins2_pan_id
_435.encounters_cpt_codes	ecp_ins3_pan_id
_436.encounters	enc_ins1_pan_id
_436.encounters	enc_pan_id
_436.encounters	enc_ins2_pan_id
_436.encounters	enc_ins3_pan_id
_436.encounters_cpt_codes	ecp_pan_id
_436.encounters_cpt_codes	ecp_ins2_pan_id
_436.encounters_cpt_codes	ecp_ins3_pan_id
_436_archive_testing.encounters	enc_ins1_pan_id
_436_archive_testing.encounters	enc_pan_id
_436_archive_testing.encounters	enc_ins2_pan_id
_436_archive_testing.encounters	enc_ins3_pan_id
_436_archive_testing.encounters_cpt_codes	ecp_pan_id
_436_archive_testing.encounters_cpt_codes	ecp_ins2_pan_id
_436_archive_testing.encounters_cpt_codes	ecp_ins3_pan_id
_437.encounters	enc_ins1_pan_id
_437.encounters	enc_pan_id
_437.encounters	enc_ins2_pan_id
_437.encounters	enc_ins3_pan_id
_437.encounters_cpt_codes	ecp_pan_id
_437.encounters_cpt_codes	ecp_ins2_pan_id
_437.encounters_cpt_codes	ecp_ins3_pan_id
_8.encounters	enc_ins1_pan_id
_8.encounters	enc_pan_id
_8.encounters	enc_ins2_pan_id
_8.encounters	enc_ins3_pan_id
_8.encounters_cpt_codes	ecp_pan_id
_8.encounters_cpt_codes	ecp_ins2_pan_id
_8.encounters_cpt_codes	ecp_ins3_pan_id
_81.encounters	enc_ins1_pan_id
_81.encounters	enc_ins2_pan_id
_81.encounters	enc_ins3_pan_id
_81.encounters_cpt_codes	ecp_pan_id
_81.encounters_cpt_codes	ecp_ins2_pan_id
_81.encounters_cpt_codes	ecp_ins3_pan_id
_999.encounters	enc_ins2_pan_id
_999.encounters	enc_ins3_pan_id
_999.encounters	enc_ins1_pan_id
_999.encounters	enc_pan_id
_999.encounters_cpt_codes	ecp_ins2_pan_id
_999.encounters_cpt_codes	ecp_ins3_pan_id
_999.encounters_cpt_codes	ecp_pan_id