MASS_RPT_PT_LN

(SQL Table)
Index Back

Mass Reporting Line Sample

This is a sample Mass Reporting Line record. Each Product should have their own. To create your own, do a save as on this record, replacing XX with your product initials. Then replace BUSINESS_UNIT with your product's list of run control parameters. Each product should have their own Mass Reporting Setup panelgroup. Panel MASS_RPT_XX should be cloned to do this.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MASS_REPORT_ID Character(30) VARCHAR2(30) NOT NULL Mass Report ID
2 MASS_REPORT_SEQ Number(6,0) INTEGER NOT NULL Mass Report Sequence
3 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

Prompt Table: RPT_PRCSDEFN_VW

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: WFEXPR_BUS_UNIT

5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department