RPT_RQST

(SQL Table)
Index Back

Report Request Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_INSTANCE Character(8) VARCHAR2(8) NOT NULL Report Instance
2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 FORMID Character(70) VARCHAR2(70) NOT NULL Form ID
4 RPT_RQST_DTTM DateTime(26) TIMESTAMP Report Request Datetime
5 RPT_DELIVERY_DTTM DateTime(26) TIMESTAMP Report Delivery Datetime
6 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
7 RPT_DELIVERY_STAT Character(1) VARCHAR2(1) NOT NULL Report Delivery Status
D=Delivered
P=Pending Delivery

Default Value: P

8 REPORT_FILENAME Character(80) VARCHAR2(80) NOT NULL Attachment
9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
10 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
11 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

Prompt Table: RPT_PRCSDEFN_VW

12 MASS_REPORT_ID Character(30) VARCHAR2(30) NOT NULL Mass Report ID
13 MASS_REPORT_SEQ Number(6,0) INTEGER NOT NULL Mass Report Sequence
14 RC_RECNAME Character(15) VARCHAR2(15) NOT NULL Run Control Recname
15 RPT_PARM1 Character(50) VARCHAR2(50) NOT NULL Report Parm 1
16 RPT_PARM2 Character(50) VARCHAR2(50) NOT NULL Report Parm 2
17 RPT_PARM3 Character(50) VARCHAR2(50) NOT NULL Report Parm 3
18 RPT_PARM4 Character(50) VARCHAR2(50) NOT NULL Report Parm 4
19 RPT_PARM5 Character(50) VARCHAR2(50) NOT NULL Report Parm 5