TSCRPT_DEFDT_VW

(SQL View)
Index Back

Default Transcript Dates

View of TSCRPT_DEFAULTS to gather date info for early/late dates.

SELECT A.TSCRPT_DEFLT_DATE , B.TSCRPT_DEFLT_DATE , C.TSCRPT_DEFLT_DATE , D.TSCRPT_DEFLT_DATE FROM PS_TSCRPT_DEFAULTS A , PS_TSCRPT_DEFAULTS B , PS_TSCRPT_DEFAULTS C , PS_TSCRPT_DEFAULTS D WHERE A.TSCRPT_DEFLT_TYPE = 'A' AND B.TSCRPT_DEFLT_TYPE = 'B' AND C.TSCRPT_DEFLT_TYPE = 'C' AND D.TSCRPT_DEFLT_TYPE = 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EARLIEST_SORT_DT Date(10) DATE This field is used to pass in default dates to the transcript generation program to be used for sorting the detail lines in the program.
2 EARLY_SORT_DT Date(10) DATE This field is used to pass in default dates to the transcript generation program to be used for sorting the detail lines in the program.
3 LATEST_SORT_DT Date(10) DATE This field is used to pass in default dates to the transcript generation program to be used for sorting the detail lines in the program.
4 LATE_SORT_DT Date(10) DATE This field is used to pass in default dates to the transcript generation program to be used for sorting the detail lines in the program.