Contents Show
The Certification Notice (Output) allows the user to print a summary report of participant information at a clinic for use as a Certification Notice document. The Certification Notice document is generated when Print Certification Notice menu option is selected on the Certification menu in the Participant Folder.
This section describes the data elements that print on the system output. Because of space constraints, the layout may be slightly different and/or all characters may not print within the space allotted.
Origin of Data Element
The title of the report will be the value of the REPORTHEADING business rule. The first subtitle of the report will be the text "Certification Notice". The second subtitle will be the full name of the participant.
Format
The participant name will print in {first name} {middle initial}. {last name} format.
Origin of Data Element
This value comes from the ServiceSiteID and Name columns of the SERVICE-SITE table.
Format
The values will print as their literal values.
Origin of Data Element
This value comes from the StaffName columns of the STAFF-MEMBER table.
Format
The values will print as their literal values.
Origin of Data Element
The value is taken from the State-WIC-ID column of the MEMBER table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the Household-ID column of the MEMBER table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the Household.MailAddress for the household of the applicant.
Format
The value prints in its literal value.
Origin of Data Element
The value is taken from the Household.MailCity for the household of the applicant.
Format
The value prints in its literal value.
Origin of Data Element
The value is taken from the Household.MailState for the household of the applicant.
Format
The value prints in its literal value.
Origin of Data Element
The value is taken from the Household.MailZIP for the household of the applicant.
Format
The value prints in #####-#### format.
Origin of Data Element
The value is taken from the Household.Telephone1 for the household of the applicant.
Format
The value prints in the format ###-###-####.
Origin of Data Element
The value is taken from the ScreenDate column of the INCOMECONTACT table.
Format
The value prints in MM/DD/CCYY format.
Origin of Data Element
The value is the lookup value from the Reference Dictionary table for WICStatus column of the MEMBER table.
Format
The value prints as its literal value.
Origin of Data Element
The value is derived from the Cert-Assigned-Priority column of the CERTCONTACT table.
Format
The value prints as its literal value.
Origin of Data Element
The value is the lookup value from the Reference Dictionary table for Race2 column of the MEMBER table.
Format
The value prints as its literal value.
Origin of Data Element
The value is derived from the Migrant column of the HOUSEHOLD table.
Format
The value prints as its literal value.
Origin of Data Element
The value is derived from the Homeless column of the HOUSEHOLD table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the DateOfBirth column of the MEMBER table.
Format
The value prints in MM/DD/CCYY format.
Origin of Data Element
The value is taken from the Auth-Rep-Last-Name, Auth-Rep-First-Name and Auth-Rep-Middle-Initial columns of the MEMBER table.
Format
The value prints in {first name} {middle initial}. {last name} format.
Origin of Data Element
The value is taken from the Alt-Auth-Rep-Last-Name, Alt-Auth-Rep-First-Name and Alt-Auth-Rep-Middle-Initial columns of the MEMBER table.
Format
The value prints in {first name} {middle initial}. {last name} format.
Origin of Data Element
The value is taken from the Proxy-Last-Name, Proxy-First-Name and Proxy-Middle-Initial columns of the MEMBER table.
Format
The value prints in {first name} {middle initial}. {last name} format.
Origin of Data Element
The value is the lookup value from the Reference Dictionary table for Identification-Proof column of the MEMBER table.
Format
The value prints as its literal value.
Origin of Data Element
The value is the lookup value from the Reference Dictionary table for Residency-Proof column of the MEMBER table.
Format
The value prints as its literal value.
Origin of Data Element
The value is the total count of records on the EDUCATION-CONTACT table for the participant.
Format
The value prints in ### format.
Origin of Data Element
The value is the lookup value from the Reference Dictionary table for the Other-Program-ID column of the OTHER-PROGRAM table.
Format
The value prints as its literal value.
Origin of Data Element
The value is the lookup value from the Reference Dictionary table for the Referral-Agency column of the REF-CONTACT table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the ScreenDate column of the INCOMECONTACT table.
Format
The value prints in MM/DD/CCYY format.
Origin of Data Element
The value is taken from the HouseholdSize column of the INCOMECONTACT table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the AnnualAmount column of the INCOMECONTACT table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the ProofOfIncome column of the INCOMEITEM table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the TANF, FoodStamps and Medicaid columns of the INCOMECONTACT table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the TANFProofCD, FoodStampsProofCD and MedicaidProofCD columns of the INCOMECONTACT table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the PresumptiveEligibilityDate column of the INCOMECONTACT table.
Format
The value prints in MM/DD/CCYY format.
The value will be the date that blood work was completed for the participant.
The system uses the earliest height/weight and blood records from the current certification to populate the height/weight and blood information on the generated Certification Notice document. The data for the Certification Notice document is retrieved from the AnthropContact and BloodWork tables.
For example, if the participant's current certification date is 03/14/2013 and two (2) height/weight measurements were recorded in the Certification Guided Script for the participant, the first with a result date of 01/01/2013 and the second with a result date of 02/02/2013, the earliest measurement with a result date of 01/01/2013 is displayed on the generated Certification Notice document.
Origin of Data Element
The value is taken from the ResultDate column of the BLOODWORK table.
Format
The value prints in MM/DD/CCYY format.
Origin of Data Element
The value is taken from the Hemoglobin column of the BLOODWORK table.
Format
The value prints in ##.# format.
Origin of Data Element
The value is taken from the Hematocrit column of the BLOODWORK table.
Format
The value prints in ##.# format.
Origin of Data Element
The value is taken from the Lead column of the BLOODWORK table.
Format
The value prints in ## format.
Origin of Data Element
The value is taken from the EP column of the BLOODWORK table.
Format
The value prints in ## format.
Origin of Data Element
The value is taken from the ExceptionReason column of the BLOODWORK table.
Format
The value prints as its literal value.
The value will be the date that the height/weight measurements were taken.
The system uses the earliest height/weight and blood records from the current certification to populate the height/weight and blood information on the generated Certification Notice document. The data for the Certification Notice document is retrieved from the AnthropContact and BloodWork tables.
For example, if the participant's current certification date is 03/14/2013 and two (2) height/weight measurements were recorded in the Certification Guided Script for the participant, the first with a result date of 01/01/2013 and the second with a result date of 02/02/2013, the earliest measurement with a result date of 01/01/2013 is displayed on the generated Certification Notice document.
Origin of Data Element
The value is taken from the MeasurementDate column of the ANTHROPCONTACT table.
Format
The value prints in MM/DD/CCYY format.
Origin of Data Element
The value is taken from the LengthInches and LengthEighths columns of the ANTHROPCONTACT table. The value of the LengthInches column will be divided by twelve to derive the number of feet. The remainder of inches and eighths will be stated together in one component (i.e. 6 2/8).
Format
The values will print in a concatenated format of measurement and literals. For example, "1 foot 2 3/8 inches" would be derived from 14 inches and three eighths.
Origin of Data Element
The value is determined using the formula supplied by the Center for Disease Control and Prevention (CDC) and the following information:
DateOfBirth column of the MEMBER table
CertWICStatus of the CERTCONTACT table
MeasurementDate, LengthInches and LengthEighths columns of the ANTHROPCONTACT table
Format
The value prints in ###.#% format if the WIC Category of the participant is either Infant or Child. Nothing will print if the WIC Category of the participant is any other value.
Origin of Data Element
The value is taken from the WeightPounds and WeightOunces columns of the ANTHROPCONTACT table.
Format
The values will print in a concatenated format of measurement and literals. For example, "147 pounds and 3 ounces" would be derived from 147 and 3 respectively in the table fields of WeightPounds and WeightOunces.
Origin of Data Element
The value is determined using the formula supplied by the Center for Disease Control and Prevention (CDC) and the following information:
DateOfBirth column of the MEMBER table
CertWICStatus of the CERTCONTACT table
MeasurementDate, WeightPounds and WeightOunces columns of the ANTHROPCONTACT table
Format
The value prints in ###.#% format if the WIC Category of the participant is either Infant or Child. Nothing will print if the WIC Category of the participant is any other value.
Origin of Data Element
The value is determined using the formula supplied by the Center for Disease Control and Prevention (CDC) and the following information:
DateOfBirth column of the MEMBER table
CertWICStatus of the CERTCONTACT table
MeasurementDate, WeightPounds WeightOunces, LengthInches and LengthEighths columns of the ANTHROPCONTACT table
Format
The value prints in ###.#% format if the WIC Category of the participant is either Infant or Child. Nothing will print if the WIC Category of the participant is any other value.
Origin of Data Element
This value is calculated if the participant was 2 years of age or older on the date that the height/weight measurements were taken. The value is calculated based on the following information:
DateOfBirth column of the MEMBER table
MeasurementDate, LengthInches, LengthEighths, WeightPounds and WeightOunces columns of the ANTHROPCONTACT table
Format
The value prints in ##.# format if the participant is a woman or a Child who is 2 years old or older. Nothing will print if the participant is an Infant or a Child who is under 2 years old.
Origin of Data Element
The value is determined using the formula supplied by the Center for Disease Control and Prevention (CDC) and the following information:
DateOfBirth column of the MEMBER table
MeasurementDate, LengthInches, LengthEighths, WeightPounds and WeightOunces columns of the ANTHROPCONTACT table
Format
The value prints in ###.#% format if the participant is a woman or a Child who is 2 years old or older. Nothing will print if the participant is an Infant or a Child who is under 2 years old.
Origin of Data Element
The value is taken from the Application-Date column of the MEMBER table.
Format
The value prints in MM/DD/CCYY format.
Origin of Data Element
The value is taken from the CertEffectiveDate column of the CERTCONTACT table.
Format
The value prints in MM/DD/CCYY format.
Origin of Data Element
The value is taken from the CertEndDate column of the CERTCONTACT table.
Format
The value prints in MM/DD/CCYY format.
Origin of Data Element
The value is the lookup value from the Reference Dictionary table for WICStatus column of the CERTCONTACT table.
Format
The value prints as its literal value.
Origin of Data Element
The value is derived from the Cert-Assigned-Priority column of the CERTCONTACT table.
Format
The value prints as its literal value.
Origin of Data Element
The value is the lookup value from the Reference Dictionary table for the RiskFactorID column of the RISKFACTOR table.
Format
The value prints as its literal value.
Origin of Data Element
The value label contains the text "(High Risk)" if the risk factor is considered to be high risk.
Format
The value prints as its literal value.
Origin of Data Element
The value is the lookup value from the STATEBUSINESSRULES table of the database where categoryID = 'REPORTHEADING'.
Format
The value prints as its literal value.
Only information for the selected participant will be included in the report.
Only income information, blood work results, anthropometric measurements and risk factors recorded during the current certification period will be included in the report.
|
Software Version: 2.40.00