RPT_RQST

index back

Report Request Table


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

Default: P

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

Prompt Table: RPT_PRCSDEFN_VW

MASS_REPORT_ID Character(30) VARCHAR2(30) NOT NULL Mass Report ID
MASS_REPORT_SEQ Number(6,0) INTEGER NOT NULL Mass Report Sequence
RC_RECNAME Character(15) VARCHAR2(15) NOT NULL Run Control Recname
RPT_PARM1 Character(50) VARCHAR2(50) NOT NULL Report Parm 1
RPT_PARM2 Character(50) VARCHAR2(50) NOT NULL Report Parm 2
RPT_PARM3 Character(50) VARCHAR2(50) NOT NULL Report Parm 3
RPT_PARM4 Character(50) VARCHAR2(50) NOT NULL Report Parm 4
RPT_PARM5 Character(50) VARCHAR2(50) NOT NULL Report Parm 5
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19