V100_HISTPRMPT (SQL View)	Index Back
Vets 100 History Prompt View This is used in the V100 Reporting run control panel as a prompt so that it is posssible to determine what history information is available for reporting on.

V100_HISTPRMPT

(SQL View)

Vets 100 History Prompt View

This is used in the V100 Reporting run control panel as a prompt so that it is posssible to determine what history information is available for reporting on.

SELECT DISTINCT V100_REPORTING_YR , V100_REPORT_TYPE FROM PS_V100_HISTORY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 V100_REPORTING_YR Character(4) VARCHAR2(4) NOT NULL Vets 100 Reporting Year

2 V100_REPORT_TYPE Character(1) VARCHAR2(1) NOT NULL VETS-100 Report Type
A=VETS-100A
B=VETS-100
C=VETS-4212

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	V100_REPORTING_YR	Character(4)	VARCHAR2(4) NOT NULL	Vets 100 Reporting Year
2	V100_REPORT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VETS-100 Report Type A=VETS-100A B=VETS-100 C=VETS-4212