Income Calculator

Contents Show

The Income Calculator screen is used to manage income eligibility information for the current client.

When an applicant is prescreened into a household for which an income contact exists for the current system date, the household income contact information is copied to the applicant's records when the prescreening process is complete.

Income items added to the Adjunctive Income Eligibility Maintenance screen in Reference Utility can also apply to all members of the household (depending on the selections made by the user).

When a certification attempt is started for a member of a household for which an income contact exists for the current system date, the CERTSTARTDATE value of the member's INCOMECONTACT record is changed to the CERTSTARTDATE value of the member's CERTCONTACT record (which will be the current system date).

When an incomplete certification is removed using the Remove Incomplete Certification menu option on the Certification menu in the Participant Folder of the Clinic application module:

Income Calculator screen

Screen Access

Screen Access

  • During the Prescreening process: Display the Applicant Prescreening screen > Click the Income Calculator button (pictured below).

  • During a Certification period: Display the Income History screen > Click the Income Calculator button (pictured below).

  • During a Certification attempt: Display the Demographics screen > Click the Income Calculator button (pictured below).

Interface Initialization

Upon initial display of the screen, the following occurs:

  • The title bar text is set to "Income Calculator".

  • The OK button is visible and enabled as the default.

  • The Cancel button is visible and enabled as the default.

If the screen is displayed from the Applicant Prescreening screen:

  • The Income Screening Contacts tree list is enabled and blank.

  • The Copy Items to Current Income button is visible and disabled.

  • The Adjunctive Eligibility group box includes an Adjunctive Eligibility Option check box and an associated Proof of Adjunctive Eligibility drop-down list box for each active adjunctive income eligibility option. The check boxes are enabled and unchecked, and the drop-down list boxes are disabled and blank.

For information about the maintenance of adjunctive income eligibility options, refer to Adjunctive Income Eligibility Maintenance in Reference Utility.

  • The Pending Proof of Income check box is enabled and defaults to unchecked if the CLN_AllowPendingProof_Income business rule is set to "Y". Otherwise, it is disabled and unchecked.

  • The Income Information data grid is enabled and blank.

  • The Add Item button is visible and enabled as the default.

  • The Edit Item button is visible and disabled as the default.

  • The Delete Item button is visible and disabled as the default.

  • The Household Size text box is visible, enabled, and initially blank as the default.

  • The Total Amount per {Period} text and value label is visible, disabled, and initially blank as the default.

If the screen is displayed from the Income History screen of the Participant Folder or the Demographics screen of the Certification Guided Script:

  • The Income Screening Contacts tree list is enabled and displays a node for the current income screening contact and a node for each previous income screening contact node recorded for the household. The node for the current system date is selected by default and expanded if individual adjunctive eligibility options have been selected for a member of the household.

  • The Original Screening Date value label is disabled and displays the original screening date recorded for the current income contact.

  • The Copy Items to Current Income button is visible and disabled.

  • The Adjunctive Eligibility group box includes an Adjunctive Eligibility Option check box and Proof of Adjunctive Eligibility drop-down list box combination for each active adjunctive income eligibility option.

If each check box is enabled:

  • If the Adjunctive Eligibility Option check box applies to individuals only, the check box displays the last value saved for the household member for the current income screening contact, or defaults to unchecked if no value has been saved.

  • If the Adjunctive Eligibility Option check box applies to the household, the check box displays the last value saved for the household for the current income screening contact, or defaults to unchecked if no value has been saved.

The Medicaid option is a special case. It applies to individuals, but if it is selected for a household member with a WIC Category of Pregnant or Infant, it is applied to each member of the household.

A drop-down list box associated with a selected check box is enabled and displays the last value saved for the current income screening contact. A drop-down list box associated with a clear check box is disabled and defaults to unchecked.

For information about the maintenance of adjunctive income eligibility options, refer to Adjunctive Income Eligibility Maintenance in Reference Utility.

  • The Pending Proof of Income check box is enabled and displays the last value saved for the household for the current income screening contact, or defaults to unchecked if no value has been saved if the CLN_AllowPendingProof_Income business rule is set to "Y". Otherwise, it is disabled and unchecked.

  • The Income Information data grid is enabled and displays a row for each income line item added for the household for the current income screening contact, or defaults to empty if no income line items have been added. If rows are displayed the first or only row is selected by default.

  • The View Details button is visible and enabled as the default.

  • The Add Item button is visible and enabled as the default.

  • The Edit Item button is visible and enabled as the default if an income line item is selected in the Income Information data grid. Otherwise, it is is visible and disabled as the default.

  • The Delete Item button is visible and enabled as the default if an income line item is selected in the Income Information data grid. Otherwise, it is visible and disabled as the default.

  • The Household Size text box is enabled and displays the last value saved for the household for the current income screening contact, or defaults to blank if no value has been saved.

  • The Total Amount per {Period} value label displays the total value of income line item(s) included in the Income Information data grid.

Screen Elements

Unless otherwise stated below, all controls on the Income Calculator screen are visible and enabled when:

If one or more special conditions exist that affect a control on the Income Calculator screen, the condition(s) are documented for that specific control below.

Income Screening Contacts tree list

  View items in the Income Screening Contacts tree list.

This tree list displays all income screening contacts for the participant's household sorted by date in descending order (when such data exists).

Click an item in the tree list to select it. The tree list is single select. Click the plus sign next to an item to expand the tree list and view the details of the item. Click the minus sign next to an item to collapse the tree list and hide the details of the item. The data values in the tree list are read-only.

The root node displays the following icon and the text:

Income Screening Contacts

Income screening contact data recorded for the household is displayed in two types of nodes when the screen is displayed from the Income History screen in the Participant Folder or the Demographic Information screen of the Certification Guided Script:

No data is displayed when the screen is displayed from the Applicant Prescreening screen.

When the income screening contact for the current system date is selected, the controls on the right side of the screen are enabled to allow the recording of income information. When a previous income screening contact is selected, the controls on the right side of the screen are disabled and display information recorded for the income contact.

When an Income Screening Contact node for a previous date is selected, the controls on the right side of the screen are populated with the data collected for the previous income screening contact. In addition:

Each check box is disabled:

Note

NOTE: The Medicaid option is a special case. It applies to individuals, but if it was selected for a household member with a WIC Category of Pregnant or Infant, it is applied to each member of the household.

Each drop-down list box is disabled and displays the value saved for the previous income screening contact.

Note

NOTE: For information about the maintenance of adjunctive income eligibility options, refer to Adjunctive Income Eligibility Maintenance.

Income Screening Contact node

The node displays the following icon and income screening contact data:

{Screening Date}, {Total Income Amount}, {Household Size}, {Income Proofs}

Below is an example of the data displayed for an income screening contact node:

Individual Adjunctive Income Eligibility Option node

The node displays the following icon and individual adjunctive income eligibility data:

{Participant Name} {Individual Adjunctive Eligibility Option}

Below is an example of the data displayed for an individual adjunctive income eligibility item node:

Original Screening Date text and value label

  View the original screening date recorded for an income screening contact node selected in the Income Screening Contacts tree list in the Original Screening Date text and value label.

Copy Items to Current Income button

  Click the Copy Items to Current Income button to copy an income item selected in the Income Screening Contacts tree list to the Current Income Information data grid.

It has a mnemonic of "C".

When the Copy Items to Current Income button is clicked for a selected previous income screening contact the following processes are started:

Verify Conflicts with Current Income Eligibility Options

A check is completed for the following conditions:

Copy Income Information Forward

Once the previous edits are completed successfully, the copy process continues:

Note

NOTE: Although the Medicaid is an individual adjunctive income eligibility option, it acts as a household adjunctive income eligibility option when it is applied to a participant with a WIC Category of Pregnant or Infant. So, if Medicaid would be copied forward for a participant who currently has a WIC Category of Pregnant or Infant, it is copied forward to the income screening contacts for all household members.

Adjunctive Eligibility group box

  Complete the information in the Adjunctive Eligibility group box.

Check the check boxes to indicate that the members of the household participate in programs and are adjunctively eligible for WIC participation. Then, select the proof of program enrollment from the drop-down list box for each adjunctive eligibility option checked.

Note

NOTE: For information about the maintenance of adjunctive income eligibility options, refer to Adjunctive Income Eligibility Maintenance.

When a Proof of Adjunctive Eligibility is selected for the Adjunctive Eligibility Option, the addition of adjunctive eligibility proof is complete.

If a check box under Adjunctive Eligibility is selected, a selection is required in the associated Proof of Adjunctive Eligibility drop-down list box.

Adjunctive Eligibility Option check box

The control allows the selection of the adjunctive income eligibility option and displays the name specified for it. If the check box is enabled, selecting the check box indicates the household member's participation in the program and provides the member and possibly the member's entire household adjunctive income eligibility in the local WIC program. Checking a check box enables the associated Proof of Adjunctive Eligibility drop-down list box. Unchecking a check box disables the associated Proof of Adjunctive Eligibility drop-down list box and clears its selection, if any.

When an adjunctive eligibility option that applies only to individuals is selected, a new Individual Adjunctive Income Eligibility Option node for the current household member is added to the Income Screening Contacts tree list under the Income Screening Contact node for the current system date.

Note

NOTE: The Medicaid option is a special case. It applies to individuals, but if it is selected for a household member with a WIC Category of Pregnant or Infant, it is applied to each member of the household. A new Individual Adjunctive Income Eligibility Option node for all household members is added to the Income Screening Contacts tree list under the Income Screening Contact node for the current system date. If it is cleared for a household member with a WIC Category of Pregnant or Infant during the same session in which it was added, it is removed from each member of the household to which it was added. If it is cleared for a household member with a WIC Category of Pregnant or Infant, during a different session from which it was added, it is removed from only that individual. The associated Individual Adjunctive Income Eligibility Option nodes for any affected household members are removed from under the Income Screening Contact node for the current system date in the Income Screening Contacts tree list.

When a check box is selected for an Adjunctive Eligibility Option that is defined as being applicable to the entire household (The INDIVIDUALONLY value in the ADJUNCTIVEINCOMEELIGIBILITY table that matches the NAME of the option selected must = "N"), and Proof of Adjunctive Eligibility drop-down list box associated with the check box contains a value, the household is adjunctively income eligible for participation in the WIC program.

When a check box is selected for an Adjunctive Eligibility Option that is defined as being applicable to the household member only (The INDIVIDUALONLY value in the ADJUNCTIVEINCOMEELIGIBILITY table that matches the NAME of the option selected must = "Y"), and Proof of Adjunctive Eligibility drop-down list box associated with the check box contains a value, the household member is adjunctively income eligible for participation in the WIC program.

Proof of Adjunctive Eligibility drop-down list box

The control allows the selection of a proof of participation in the selected Adjunctive Eligibility Option.

The control is enabled when:

It is populated with all participation proofs to be selected.

Pending Proof of Income check box

  Select the Pending Proof of Income check box to indicate the client has neither proof of participation in an Adjunctive Eligibility program nor proof of income for the Income Information.

The control is enabled when:

If this check box is checked, it updates all other household members to be pending proof of income. When proof of income is obtained and this check box is unchecked, it updates the proof of income for all other household members.

Income Information group box

  Complete the information in the Income Information group box.

Click an income record in this data grid to select it for editing or deleting. This data grid displays all income records for the client. The following are associated with this data grid:

Income Information data grid

The control displays income recorded for the income screening contact. A row is displayed in the data grid for each income line item. The data grid includes the following columns:

When income line items have been recorded for the household (all income line items displayed in the Income Information data grid apply to the entire household), the values of all income line items added for the income screening contact are totaled and compared to the federal guidelines for income established for the current fiscal year, based on the size of the household and the value of the INCOMEVIEWFREQ state business rule. The income thresholds are stored in the INCOMEELIGIBILITYAMOUNT table.

For example, if the fiscal year is 2010, the household size is three, and the INCOMEVIEWFREQ state business rule is one (Yearly), the sum of all income line items is compared to the ANNUALAMOUNT value in the INCOMEELIGIBILITYAMOUNT table where the FISCALYEAR value is "2010" and the HOUSEHOLDSIZE value is "3". If the sum of all income line items for the income screening contact is less than or equal to the ANNUALAMOUNT value, the household is income eligible for participation in the WIC program. However, if the sum of all income line items for the income screening contact is greater than the ANNUALAMOUNT value, the household is income ineligible for participation in the WIC program.

The data grid consists of the following control(s):

Frequency column

This column displays the frequencies selected for the income line items for each record displayed within the data grid.

The title of the column is set to "Frequency". The information displayed within the column is read-only.

The following values are valid (as defined in the Reference Dictionary where the category = INCOMFREQD):

Description column

This column displays the description for each record displayed within the data grid.

The title of the column is set to "Description". The information displayed within the column is read-only. The column header and the data within the column are left aligned.

The cells in the column display the descriptions of the income line items. The following formats are valid (as defined in the Reference Dictionary where the category = INCOMFREQ):

Note

NOTE: The values displayed in place of the pound (#) symbols are the values stored for the income line items and are collected when the income line items are added or edited on the Income Line Item screen.

Amount per {Period} column

This column displays the total amount calculated for the income line items rounded to the nearest whole dollar displayed within the data grid.

The title of the column is set to "Amount per {Period}". The information displayed within the column is read-only.

The text displayed for the column heading is determined by the value of the INCOMEVIEWFREQ state business rule. If the value of the business rule is "1", the text displayed is "Amount per Year". If the value of the business rule is "12", the text displayed is "Amount per Month". If the value of the business rule is "52", the text displayed is "Amount per Week". The following calculations are defined for the indicated frequencies:

Note

NOTE: The Number of Weeks, Number of Months, and Number of Periods values are static values when the INCOMEVIEWFREQ state business rule is set to "12" or "52" and are determined by the same.

Add Item button

Click the Add Item button to add an income record.

It has a mnemonic of "A".

The Income Line Item screen displays in Add mode when the button is clicked.

Upon successful processing of the Income Line Item screen, an income line item is added for the current income screening contact.

When an income line item is added, the following actions occur:

Edit Item button

Click the Edit Item button to edit the income item selected in the data grid.

The control is enabled when:

It has a mnemonic of "E".

The Income Line Item screen displays in Edit mode when the button is clicked.

When the income screening contact for the current system date is edited, the Original Screening Date value is set to the current system date.

Upon successful processing of the Income Line Item screen, the selected income line item is updated for the current income screening contact.

When an income line item is edited, the following actions occur

Delete Item button

Click the Delete Item button to delete an income item selected in the data grid.

The control is enabled when:

It has a mnemonic of "D".

A standard confirmation message (C0004) displays when the button is clicked. The options of Yes and No are available. If the user clicks Yes, the system deletes the record from the database. The contents on the Income Calculator screen are refreshed. If the user clicks No, the system returns to the Income Calculator screen without deleting the selected record.

When an income line item is deleted, the following actions occur:

Household Size masked edit box

Enter the number of members in the client's household.

The Household Size value must be between 1 and 20.

Total Amount per {Period} text and value label

The text and value label displays the period for which the household income is totaled and the calculated total household income amount. The text displayed for the value label is determined by the value of the INCOMEVIEWFREQ state business rule. If the value of the business rule is "1", the text displayed is "Total Amount per Year". If the value of the business rule is "12", the text displayed is "Total Amount per Month". If the value of the business rule is "52", the text displayed is "Total Amount per Week".

The value label displays the sum of the values displayed in the Total Amount per {Period} column in "$###,###.##" format.

The information displayed is read-only. The value label displays in the inverse color of the screen.

OK button

  Click the OK button to process the screen.

It is the default button for the screen, unless otherwise noted.

It does not have a mnemonic. Its keyboard shortcut is the Enter key.

Depending on which screen originally called the Income Calculator screen, one of the following screens displays when the button is clicked:

A check is performed to ensure required information is provided for the current income screening contact:

One of the following must be true for the income information:

If none of the three conditions are true for the income information, the system displays the E0061 standard error message.

When the above income eligibility checks are completed, the following occurs:

If the Income Contact was displayed from the Applicant Prescreening screen:

If the Income Contact was displayed from the Income History screen of the Participant Folder or the Demographics screen of the Certification Guided Script:

When the edits are completed successfully, if the Income Calculator screen was displayed from the Income History screen of the Participant Folder or the Demographics Information screen of the Certification Guided Script, the income contact information is saved.

If a new income contact was created, the following occurs:

If an income contact is updated, the following occurs:

Cancel button

Click the Cancel button to close the screen without processing or saving data.

It does not have a mnemonic. Its keyboard shortcut is the Esc (escape) key.

Depending on which screen originally called the Income Calculator screen, one of the following screens displays when the button is clicked:

Note

NOTE: To meet income eligibility guidelines, one of the following criteria must be satisfied:

  • Adjunctive Eligibility must be established by selecting a check box under Adjunctive Eligibility.

  • Presumptive Eligibility must established by selecting the Pending Proof of Income check box.

  • Income Eligibility must be established through the creation of one or more qualifying income records in the Income Information data grid. Income records can be created in the Income Information data grid either through the use of the Copy Items to Current Income button or through the use of the Add Item button.

Processing

If data can be validated and saved on the screen, the following processes occur when the screen is processed:

If no data can be validated and saved on the screen:

Data Map

The Data Map defines the values saved for all controls on the screen. If available, any additional notes or comments are displayed in the Notes column.

Table Name: AdjunctiveIncomeEligibility

Column Name

Data Type

Description

Associated Control

AdjunctiveID

Primary Key, Int, Not NULL

Identity Value, Identifies the adjunctive income eligibility option.

N/A

AdjunctiveType

Int, Not NULL

Identifies the adjunctive income eligibility option as one of the four standard types or an additional type (optional):

1 = Food Stamps

2 = TANF

3 = Medicaid

4 = FDPIR

0 = Optional

N/A

Name

VarChar (20), Not NULL

The name displayed for the adjunctive income option on the Income Calculator screen.

The names of the check boxes in the Adjunctive Eligibility group box

Active

Char (1), NULL

A yes (Y) or no (N) Boolean flag that identifies the adjunctive income eligibility option as active or inactive.

N/A

IndividualOnly

Char (1), NULL

A yes (Y) or no (N) Boolean flag that identifies the adjunctive income eligibility option as giving adjunctive income eligibility to the individual household member it is assigned to or the member's entire household.

N/A

CreateUserID

VarChar (20), NULL

Stores the UserID of the user logged into the system at the time the record was created.

N/A

CreateDTTM

DateTime, NULL

Stores the date and time at which the record was created.

N/A

ModifyUserID

VarChar (20), NULL

Stores the UserID of the user logged into the system at the time the record was modified.

N/A

ModifyDTTM

DateTime, NULL

Stores the date and time at which the record was modified.

N/A

Table Name: IncomeContact

Column Name

Data Type

Description

Associated Control

StateWICID

Primary Key, VarChar(8), Not NULL

The system-assigned code uniquely identifying the member within the state.

N/A

ScreenDate

Primary Key, DateTime, Not NULL

The date on which the income screening contact was completed. When the income contact is created, the value is populated with the system date.

The date displayed for an income screening contact node in the Income Screening Contacts tree list.

CertStartDate

DateTime, NULL

The start date of the certification attempt during which the record was added, if applicable.

N/A

AnnualAmount

Numeric (8, 0), NULL

The annualized income amount for all income sources reported for the member during this contact.

If the INCOMEVIEWFREQ state business rule is set to "1":

The dollar amount displayed for an income screening contact in the Income Screening Contacts tree list and the total amount displayed below the income information data grid.

MonthlyAmount

Numeric (8, 0), NULL

The calculated monthly income amount for all income sources reported for the member during this contact.

If the INCOMEVIEWFREQ state business rule is set to "12":

The dollar amount displayed for an income screening contact in the Income Screening Contacts tree list and the total amount displayed below the Income Information data grid.

WeeklyAmount

Numeric (8, 0), NULL

The calculated weekly income amount for all income sources reported for the member during this contact.

If the INCOMEVIEWFREQ state business rule is set to "52":

The dollar amount displayed for an income screening contact in the Income Screening Contacts tree list and the total amount displayed below the Income Information data grid.

HouseholdSize

Numeric (2, 0), NULL

The size of the household at the time of the income screening contact.

The value displayed in the Household Size text box and the household size displayed for an income screening contact node in the Income Screening Contacts tree list.

PresumptiveEligibilityDate

DateTime, NULL

The date on which the member is presumed to be eligible for Medicaid benefits and subsequently WIC benefits.

N/A

PendingProof

Char (1), NULL

A flag indicating that no proof of income was provided at the time of the income screening.

The value indicated by the Pending Proof of Income check box.

TANF

Obsolete

The repository for this data has been moved to the newly created INCOMECONTACTADJUNCTIVEITEM database table.

N/A

FoodStamps

Obsolete

The repository for this data has been moved to the newly created INCOMECONTACTADJUNCTIVEITEM database table.

N/A

Medicaid

Obsolete

The repository for this data has been moved to the newly created INCOMECONTACTADJUNCTIVEITEM database table.

N/A

Other

Obsolete

The repository for this data has been moved to the newly created INCOMECONTACTADJUNCTIVEITEM database table.

N/A

FDPIR

Obsolete

The repository for this data has been moved to the newly created INCOMECONTACTADJUNCTIVEITEM database table.

N/A

TANFProofCD

Obsolete

The repository for this data has been moved to the newly created INCOMECONTACTADJUNCTIVEITEM database table.

N/A

FoodStampsProofCD

Obsolete

The repository for this data has been moved to the newly created INCOMECONTACTADJUNCTIVEITEM database table.

N/A

MedicaidProofCD

Obsolete

The repository for this data has been moved to the newly created INCOMECONTACTADJUNCTIVEITEM database table.

N/A

OtherProofCD

Obsolete

The repository for this data has been moved to the newly created INCOMECONTACTADJUNCTIVEITEM database table.

N/A

FDPIRProofCD

Obsolete

The repository for this data has been moved to the newly created INCOMECONTACTADJUNCTIVEITEM database table.

N/A

UpdateRecord

Char (1), NULL

A code indicating whether the record has been updated:

N = New

U = Updated

NULL = Processed

N/A

CreateUserID

VarChar (20), NULL

Identifies the user who created the record.

N/A

CreateDTTM

DateTime, NULL

The date/time stamp identifying when the record was created. The value is populated with the system date.

N/A

ModifyUserID

VarChar (20), NULL

Identifies the user who modified the record.

N/A

ModifyDTTM

DateTime, NULL

The date/time stamp identifying when the record was modified. The value is populated with the system date.

N/A

OriginalScreenDate

DateTime, NULL

The original screening date for the income contact. When the income contact is created, the value is populated with the system date. When a previous income screening contact is copied forward, the value is populated with the OriginalScreenDate value of the copied income contact.

The value displayed as the Original Screening Date value label for the income screening contact selected in the Income Screening Contacts tree list.

Table Name: IncomeItem

Column Name

Data Type

Description

Associated Control

StateWICID

Primary Key, VarChar(8), Not NULL

The system-assigned code uniquely identifying the member within the state.

N/A

ScreenDate

Primary Key, DateTime, Not NULL

The date on which the income screening contact was performed.

N/A

LineItemID

Primary Key,

Numeric(10,0),

Not NULL

The system-assigned code uniquely identifying the income item.

N/A

Frequency

Char(1),

NULL

A code indicating the frequency with which the amount of the income item is received. (Refer to the INCOMFREQ category in the Reference Dictionary database table.)

The frequency displayed for an income line item in Frequency Column of the Income Information data grid.

Amount

Numeric(12,4).

The amount of the income item is received.

The amount displayed for an income line item in the Description column of the Income Information data grid.

UpdateRecord

Char (1), NULL

A code indicating whether the record has been updated:

N = New

U = Updated

NULL = Processed

N/A

HoursPerWeek

Numeric(3,0),

NULL

The number of hours worked per week when the income frequency is hourly.

The hours displayed for an income line item in the Description column of the Income Information data grid when the frequency is hourly.

Duration

Numeric(2,0),

NULL

The number of weeks, periods, or months when the income frequency is weekly, bi-weekly, monthly, or semi-monthly.

The duration displayed for an income line item in the Description column of the Income Information data grid.

ProofOfIncome

Char (1),

NULL

A code indicating the proof of income presented for the income line item. (Refer to the INCOMPROOF category in the Reference Dictionary database table.)

The proof of income displayed for an income screening contact node in the Income Screening Contacts tree list.

CreateUserID

VarChar (20), NULL

Identifies the user who created the record.

N/A

CreateDTTM

DateTime, NULL

The date/time stamp identifying when the record was created. The value is populated with the server system date.

N/A

ModifyUserID

VarChar (20), NULL

Identifies the user who modified the record.

N/A

ModifyDTTM

DateTime, NULL

The date/time stamp identifying when the record was modified. The value is populated with the server system date.

N/A

Table Name: IncomeContactAdjunctiveItem

Column Name

Data Type

Description

Associated Control

StateWICID

Primary Key, VarChar(8), Not NULL

The system-assigned code uniquely identifying the member within the state.

N/A

ScreenDate

Primary Key, DateTime, Not NULL

The date on which the income screening contact was performed.

The date displayed for an income screening contact node in the Income Screening Contacts tree list.

AdjunctiveID

Primanry Key,

Int,

Not NULL

A code uniquely identifying the adjunctive income eligibility item selected.

The adjunctive income eligibility item the code identifies can be found by matching the AdjunctiveID value to the value in the ADJUNCTIVETYPE column of the ADJUNCTIVEINCOMEELIGIBILITY database table.

The identifier for the Adjunctive Eligibility check box selected.

ProofCode

Char(2),

NULL

A code uniquely identifying the proof of adjunctive eligibility presented for the income contact. The proof that the code identifies can be found by matching the ProofCode value to the value in the EXTERNALID column of the Reference Dictionary table where the value in the category column is 'FDPIRPROOF', 'MEDICAIDPROOF', 'SNAPPROOF', 'TANFPROOF', or 'OTHERPROOF', depending on the adjunctive eligibility type.

The identifier for the Adjunctive Eligibility proof of participation selected.

IndividualOnly

Char(1),

NULL

A flag that identifies whether the adjunctive eligibility income item applies to the individual only or to all members of the member's household.

N/A

CreateUserID

VarChar (20), NULL

Identifies the user who created the record.

N/A

CreateDTTM

DateTime, NULL

The date/time stamp identifying when the record was created. The value is populated with the system date.

N/A

ModifyUserID

VarChar (20), NULL

Identifies the user who modified the record.

N/A

ModifyDTTM

DateTime, NULL

The date/time stamp identifying when the record was modified. The value is populated with the system date.

N/A

|

Clinic