Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| reporting_month | date | 6 | √ | null |
|
|
||||
| work_date | datetime | 16,3 | null |
|
|
|||||
| epi_id | int | 4 | √ | null |
|
|
||||
| epi_branchcode | char | 3 | √ | null |
|
|
||||
| branch_groupname | varchar | 200 | null |
|
|
|||||
| branch_serviceline | varchar | 200 | null |
|
|
|||||
| worker_id | int | 4 | null |
|
|
|||||
| wkr_lastname | varchar | 50 | √ | null |
|
|
||||
| wkr_firstname | varchar | 50 | √ | null |
|
|
||||
| wkr_signaturetitle | varchar | 30 | √ | null |
|
|
||||
| s_id | int | 4 | null |
|
|
|||||
| epi_lastname | varchar | 50 | √ | null |
|
|
||||
| wc_code | varchar | 4 | null |
|
|
|||||
| wc_desc | varchar | 50 | null |
|
|
|||||
| pc_desc | varchar | 25 | √ | null |
|
|
||||
| CEV_ID | int | 4 | √ | null |
|
|
||||
| hours_worked | numeric | 19,6 | √ | null |
|
|
||||
| ptg_description | varchar | 25 | null |
|
|
|||||
| ptg_productivitypointspervisit | decimal | 20,2 | null |
|
|
|||||
| wjt_desc | varchar | 50 | null |
|
|
|||||
| wt_desc | varchar | 50 | null |
|
|
|||||
| sc_code | varchar | 10 | √ | null |
|
|
||||
| dsc_code | char | 4 | √ | null |
|
|
||||
| ss_desc | varchar | 50 | null |
|
|
|||||
| routine_11_flag | varchar | 1 | null |
|
|
|||||
| prof_clin_flag | varchar | 1 | null |
|
|
|||||
| training_flag | varchar | 1 | null |
|
|
|||||
| timeoff_flag | varchar | 1 | null |
|
|
Relationships
Close relationships within degrees of separation
