Contents Show
The Action Date Due Report VND022 (Output) displays vendors that have events or follow-up activities that have passed the action date. The report is generated when the OK button is clicked on the Generate Action Date Due Report screen.
The Action Date Due Report VND022 (Output) displays all of the vendors' action dates that are due based on the current system date. An action date is an action that is due when there is no follow-up activity under its event or follow-up activity. An example could be a Letter Sent for the event or follow-up activity.
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
This value is recorded when the report is submitted. It is the date the report was run.
Format
The date value prints in MM/ CCYY format.
Origin of Data Element
For events, this value is the Vendor column of the Event table. For follow ups, this value is the Vendor column of the FollowUpActivity table.
Format
This value is a six-character value.
Origin of Data Element
The name value comes from the TradeName column of the Vendor table. The address value is the Address1, Address2, City, StateCd and ZIPCd columns of the Address table.
The VendorID column of the selected records from the FoodInstrument table is used to get the AddressID column of the AddressCrossRef table where the following is true:
VendorID column of the FoodInstrument table equals the AddressID column of the AddressCrossRef table.
TableName column of the AddressCrossRef table equals the Description column of the Reference Dictionary table where the category column of the Reference Dictionary table = "AddressTableNames" and the ExternalID column of the Reference Dictionary table = "VENDOR".
AddressType column of the AddressCrossRef table equals = "PHYS".
Active column of the AddressCrossRef table equals = "Y".
The AddressID column of the AddressCrossRef table is used to get the Address1, Address2, City, StateCd and ZIPCd columns of the Address table.
Format
The name and addresses are fifty-character values. The city is a thirty-character value. The state code is a two-character value. The zip code is a nine-character value.
Origin of Data Element
This value comes from the Description column of the Reference Dictionary table for category = "EVENTTYPE" where the ExternalID column of the Reference Dictionary table is equal to the Type column of either the Event table or the FollowUpActivity table.
Format
This is a fifty-character value.
This value is the date when the event or follow-up activity is due.
Origin of Data Element
This value is calculated by adding X number of days to the CreateDate column of the either the Event table or the FollowUpActivity table. The X number of days is the Days column of the ActionDates table for the associated Type column of the Event table or the FollowUpActivity table.
Format
This is a date in the format of MM/DD/CCYY.
Vendors with either events or follow-ups that have reached the end of their action dates are included in this report.
Events listed on the report must meet the following selection criteria:
The EventID column of the Event table is not an EventID on the EventRelationship table.
The Type columnof the Event table equals a value on the Reference Dictionary table for category column equals "EVENTTYPE".
The value of the Type column of the Event table is one of the values of the EventFollowUpID column of the ActionDate table where the Days column of the ActionDate table is not equal to "-999".
The calculated action date is less than the current date. The calculated action date is the determined by adding X number days to the CreateDate column of the Event table. The X number of days is the Days column of the ActionDates table for the associated Type column of the Event table.
Follow-ups listed on the report must meet the following selection criteria:
The FollowUpActivityID column of the FollowUpActivity table is not a ParentFollowUpActivity on the FollowUpRelationship table.
The Type column of the FollowUpActivity table equals a value on the Reference Dictionary table for category column equals "EVENTTYPE".
The value of the Type column of the FollowUpActivity table is one of the values of the EventFollowUpID column of the ActionDate table where the Days column of the ActionDate table is not equal to "-999".
The calculated action date is less than the current date. The calculated action date is the determined by adding X number days to the CreateDate column of the FollowUpActivity table. The X number of days is the Days column of the ActionDates table for the associated Type column of the FollowUpActivity table.
This report will be sorted by vendor ID using an alphanumeric sort order. The vendor ID is sorted in ascending order from left to right in the ID, and then by length from shortest to longest.
This report will be sorted by Action Date in reverse chronological order within vendor ID.
This report will be sorted by the Event/Follow-up text within Action Date.
Grand totals are not applicable for this report.
|
Software Version: 2.40.00
