GYN_CCS_FOLLOWUP_REPL

Description:

This table should not be queried directly. It is used by the GYN_CCS_FOLLOWUP view and will ultimately be deprecated. This table contains the cervical cancer screening follow-up actions for patients.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	GYN_FOLLOWUP_C_NAME	VARCHAR	No
	Follow-up action that has been set for the patient. May contain organization-specific values: Yes Category Entries: Ablation Excision Endometrial biopsy Endocervical curettage Colposcopy Colposcopy in 4 months Colposcopy in 6 months Colposcopy in 12 months Colposcopy post-partum HPV testing HPV testing in 6 months HPV testing in 12 months HPV testing in 2 years HPV testing in 3 years HPV testing in 5 years HPV typing HPV typing 16/18 Cotesting Pap Pap in 6 months Pap in 12 months Pap in 2 years Pap in 3 years Pap in 5 years Pap post-partum Refer to GYN Refer to GYN ONC Screening no longer indicated Other Colposcopy in 2 years Colposcopy in 3 years Colposcopy in 5 years Colposcopy immediately HPV testing in 4 months HPV testing immediately Pap in 4 months Pap immediately
4	GYN_FOLLOWUP_USER_ID	VARCHAR	No
	The user that entered the follow-up action.
5	GYN_FOLLOWUP_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	GYN_FOLLOWUP_DTTM	DATETIME (UTC)	No
	The instant that the follow-up action is entered.
7	GYN_FOLLOWUP_RESP_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
8	GYN_FOLLOWUP_DUE_DATE	DATETIME	No
	Stores the due date for the related Cervical Cancer Screening follow-up actions.