Cashier Proof of Employment by ujd66827

VIEWS: 49 PAGES: 9

More Info
									                                                               On-line
                                                               System
                                                               Provider                                           Mapped
                                                               Type                                               "from"
field_name   code   descriptor                                 Code     On-line System Descriptor                 Value    Notes                                   QA
PROV_ID      1A     1A-Audiologist                                   12   Audiologist                             1A                                               x
PROV_ID      1B     1B-Clinical Psychologist                         27   Psychologist                            1B                                               x
PROV_ID      1C     1C-Clinical Social Worker                        14   Clinical Social Worker                  1C                                               x
PROV_ID      1D     1D-Dietician                                     28   Registered Dietician                    1D                                               x
PROV_ID      1E     1E-Marriage and Family Counselor                 17   Marriage & Family Therapist             1E                                               x
PROV_ID      1F     1F-Mental Health Counselor                       18   Mental Health Counselor                 1F                                               x
                                                                          Advanced Registered Nurse
PROV_ID      1G     1G-Nurse Practitioner                            10   Practitioner                            1G                                               x
PROV_ID      1H     1H-Nutritionist                                  15   Dietetics/Nutritionist                  1H                                               x
                                                                     19   Nutrition Counselor                              New descriptor and code                 x
PROV_ID      1J     1J-Occupational Therapist                        20   Occupational Therapist                  1J                                               x

PROV_ID      1K     1K-Occupational Therapist Assistant              21   Occupational Therapist-Assistant        1K                                               x
PROV_ID      1L     1L-Physical Therapist                            23   Physical Therapist                      1L                                               x
PROV_ID      1M     1M-Physical Therapist Assistant                  24   Physical Therapist Assistant            1M                                               x
PROV_ID      1N     1N-Practical Nurse                               16   Licensed Practical Nurse                1N                                               x
PROV_ID      1P     1P-Registered Nurse                              29   Registered Nurse                        1P                                               x
PROV_ID      1Q     1Q-School Psychologist                           31   School Psychologist                     1Q                                               x
PROV_ID      1R     1R-Speech Language Pathologist                   32   Speech Language Pathologist             1R                                               x

PROV_ID      1S     1S-Speech Language Pathologist Assistant         33   Speech Language Pathologist-Assistant   1S                                               x
PROV_ID      2A     2A-ITDS with cert. from approved program         38   ITDS                                    2A                                               x
PROV_ID      2B     2B-ITDS without certificate                      38   ITDS                                    2B                                               x
PROV_ID      3A     3A-Service Coordinator                           40   Service Coordinator                     3A                                               x
PROV_ID      4A     4A-Certified Behariov Analyst                    34   Certified Behavior Analyst              4A                                               x
PROV_ID      4B     4B-Hearing Specialist                            37   Hearing Specialist                      4B                                               x
                                                                                                                           Per CMS - do not map these records to
PROV_ID      4C     4C-Orientation and Mobility Specialist                                                                 the on-line system
PROV_ID      4D     4D-Special Instruction Consultant                42 Special Instruction Consultant            4D                                               x
PROV_ID      4E     4E-Vision Specialist                             43 Vision Specialist                         4E                                               x

PROV_ID      4G     4G-Certified Associate Behavior Analyst          35 Certified Behavior Analyst - Associate    4G                                               x
                                                                                                                           Per CMS - do not map these records to
PROV_ID      5B     5B-ES Service Area Coordinator                                                                         the on-line system
                                                                                                                           Per CMS - do not map these records to
PROV_ID      5A     5A-ES Service Area Director                                                                            the on-line system
                                                                                                                           Per CMS - do not map these records to
PROV_ID      5C     5C-Family Resource Specialist                                                                          the on-line system
                                                                                                                           Per CMS - do not map these records to
PROV_ID      5E     5E-Other Specify                                                                                       the on-line system
                                                            On-line
                                                            System
                                                            Provider                                    Mapped
                                                            Type                                        "from"
field_name   code   descriptor                              Code     On-line System Descriptor          Value    Notes                                   QA
                                                                                                                 Phase IV - Pending conversion
PROV_ID      6A     6A-Local Education Agency Provider                                                           instruction from DOH
                                                                                                                 Phase IV - Pending conversion
PROV_ID      6B     6B-Dept of Children & Family Provider                                                        instruction from DOH
                                                                                                                 Per CMS - do not map these records to
PROV_ID      6D     6D-Other Specify                                                                             the on-line system
                                                                                                                 Per CMS - do not map these records to
PROV_ID      4F     4F-Other Specify                                                                             the on-line system
PROV_ID      1O     1O-Physicians                                  4   Medical Doctor                   1O                                               x
                                                                   5   Doctor of Osteopathy             1O                                               x
                                                                   6   Dentist DMD                      1O                                               x
                                                                   7   Dentist DDS                      1O                                               x
                                                                                                                 Per CMS - do not map these records to
PROV_ID      5D     5D-Service Coordinator Supervisor                                                            the on-line system
                                                                                                                 Phase IV - Pending conversion
PROV_ID      5F     5F-Equipment Vendor                                                                          instruction from DOH
                                                                                                                 Phase IV - Pending conversion
PROV_ID      5G     5G-Interpreter                                                                               instruction from DOH
                                                                                                                 Phase IV - Pending conversion
PROV_ID      6C     6C-Insurance Network Provider                                                                instruction from DOH

                                                                                                                 New descriptor and code from Phase II
                                                                  30 Registered Respiratory Therapist            conversion of licensed                  x
                                                                                                                 New descriptor and code from Phase II
                                                                  22 Optometrist                                 conversion of licensed                  x
                                                                     Chiropractor                                New descriptor and code from Phase II
                                                                  13                                             conversion of licensed                  x
                                                                     Podiatrist                                  New descriptor and code from Phase II
                                                                  25                                             conversion of licensed                  x
                                                                     Physicians Assistant (PA)                   New descriptor and code from Phase II
                                                                  11                                             conversion of licensed                  x
                                                                     Provisional Licensed SLP                    New descriptor and code from Phase II
                                                                  26                                             conversion of licensed                  x
                                                                     Social Worker
                                                                                                                 New descriptor and code from Phase III
                                                                  41                                             conversion of unlicensed               x
                                                                            On-line System
                                                                            Participation
     STATUS_ID               STATUS_DESC                 UF Note            Status Code

A                Application Received

A1               Packet Received

A2               File Completed-Being Reviewed

A3               New Application Date
B                Temporary Approval Assigned             *equivalent to C                3

B2               Interim Approval Assigned                                               3
C                Active Status Approved                  *equivalent to B                1

D                Service Coodination Level II Training
E                Terminated/Mailed to provider                                           6

E2               Expiration Date

E3               Packet Destroyed

F                Application Updated

F2               Documentation Received EMAIL Sent

G                pre-July 1 Validated

H                Special Certification Received

I                Diploma Received

I1               Transcripts Received

J                Proof of Experience Received

K                Medicaid Validated

K1               Medicaid Application Received

K2               Medicaid Application Sent to ACS

L                Liability Insurance Received

L1               Insurance Employment Letter Received

M                Fingerprint Card Received
                 Cashier Check/Money Ord Rcvd
M1               Fingerprint
M2   FBI Background IN Process

M3   FBI Background Processed

N    Required Training Completion

O    6 month mentorship completed

P    3 month mentorship completed
     ITDS Modules completed within 12
Q    months

R    ITDS Certificate validated

S    Terms and Conditions Form Received

T    Professional License Received

U    Required inservice/CEU hours validated

V    Date of renewal enrollment application

V1   Apprenticeship completion date

W    Renewal application approved

W2   30 Day termination warning letter sent

W3   30 Days

W4   60 Days

W5   90 Days

W6   120 Days

W7   Less than 180 Days

W8   Greater than 180 Days

X    Mentorship Starting Date

Y    Mentorship Completion Date

Y1   ITDS Module 1 Completed

Y2   ITDS Module 2 Completed

Y3   ITDS Module 3 Completed

Y4   ITDS Module 4 Completed
Y5   ITDS Module 5 Completed

Y6   ITDS Module 6 Completed

Z    ES Module 1 Orientation Completed

Z1   ES Module 2 OrientationCompleted

Z2   ES Module 3 Orientation Completed
                                         2
                                         4
                                         5

                                         7
                                         8
                                         9
                          Mapped
                          "from"
On-line System Descriptor Value    Notes
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
Temporary               B
                                   Does not map to particpation
Temporary               B2         status code field
Active (3 years)        C
                                   Does not map to particpation
                                   status code field
Terminated              E
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
                                   Does not map to particpation
                                   status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
Does not map to particpation
status code field
                             Does not map to particpation
                             status code field
                             Does not map to particpation
                             status code field
                             Does not map to particpation
                             status code field
                             Does not map to particpation
                             status code field
                             Does not map to particpation
                             status code field
Emeritus (3 years)           New descriptor and code
Emergency (3 months)         New descriptor and code
Suspended                    New descriptor and code

Initial Application Denied   New descriptor and code
Bogus Application            New descriptor and code
Conv Status NULL             New descriptor and code
Early Steps database      Image API CMS provider database           NOTES:
                                                                    The Provider Information ID or (Prov_Info_ID) is referenced in each table back to the PK column in
EIPPROVS.SEQ_NBR          TBLCMS_Prov_Info.PK                       the main TBLCMS_Prov_Info table. SEQ_NBR is no longer used after data conversion.

EIPPROVS.LAST_NAME        TBLCMS_Prov_Info.Last_Name

EIPPROVS.FIRST_NAME       TBLCMS_Prov_Info.First_Name

EIPPROVS.MIDDLE_NAME      TBLCMS_Prov_Info.MI
                                                                    We will store each address in the TBLCMS_Prov_Address table with a corresponding value
                                                                    indicating the address type. 1 = BUSINESS_PRACTICE, 2 = OTHER_PRACTICE, 3 = HOME, 4 =
                                                                    CALL_COVERAGE, 5 = BILLING.
EIPPROVS.ADDRESS1         TBLCMS_Prov_Address.Addr1                 For the purpose of this output we will use the "1" for business address.

EIPPROVS.ADDRESS2         TBLCMS_Prov_Address.Addr2

EIPPROVS.CITY             TBLCMS_Prov_Address.City
                                                                    LUCMS_State is a lookup table containing the States, Names, and Abbreviations. The
EIPPROVS.STATE            LUCMS_State.State_abbr                    TBLCMS_Prov_Address table references this with the LU_State_ID column for each record.

EIPPROVS.ZIP              TBLCMS_Prov_Address.Zip
                                                                    This column references the PK column in LUCMS_County lookup table which contains information
                                                                    for all 67 counties in FL and adjacent counties in GA and AL. The numeric county code matches
EIPPROVS.CNTY_CODE        TBLCMS_Prov_Address.LU_County_ID          the older values that came from the Early Steps database.

EIPPROVS.BUS_PHONE        TBLCMS_Prov_Address.Telephone

EIPPROVS.SSN              TBLCMS_Prov_Info.SSN

EIPPROVS.FAX_NO           TBLCMS_Prov_Address.Fax

EIPPROVS.EMAIL            TBLCMS_Prov_Address.Email

EIPPROVS.FEDERAL_ID       TBLCMS_Prov_Info.NPI
                                                                    TBLCMS_Prov_Type contains information regarding the provider types. See the tab of this
                                                                    spreadsheet called "Provider Types". A provider can have multiple records in this table for the
                                                                    same type and different dates. Also multiple records for different prov_types. NEED TO DISCUSS
PROVSTAT.SEQNBRPROVTYPE   TBLCMS_Prov_Type.LU_Prov_Type_ID          HOW THIS WILL BE PRESENTED -JRH

PROVSTAT.ACTIVITY         TBLCMS_Prov_Type.LU_Part_Status_ID        Particpation Status codes are reflected on the tab of this spreadsheet called "Status Codes"

PROVSTAT.STATUS_DATE      TBLCMS_Prov_Type.Date_Status_Determined


No longer used

								
To top