RPT_RQST_VW

index back

Report Request View


select REPORT_INSTANCE, PROCESS_INSTANCE, FORMID, RPT_RQST_DTTM, RPT_DELIVERY_DTTM, ROLEUSER, RPT_DELIVERY_STAT, REPORT_FILENAME, OPRID, RUN_CNTL_ID, PRCSNAME, MASS_REPORT_ID, MASS_REPORT_SEQ, RC_RECNAME, RPT_PARM1, RPT_PARM2, RPT_PARM3, RPT_PARM4, RPT_PARM5 from PS_RPT_RQST

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
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
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