HRS_LETGEN

(SQL Table)
Index Back

Temp Table for Letter Gen

This is a temporary work area used by the system during Letter Generation.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_LETTER_ID Number(15,0) DECIMAL(15) NOT NULL Letter Id counter
2 HRS_REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL The Fusion Publisher Report Definition ID used by Recruiting
3 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.
4 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).