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 NameField TypeColumn TypeDescription
REPORT_INSTANCECharacter(8)VARCHAR2(8) NOT NULLReport Instance
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
FORMIDCharacter(70)VARCHAR2(70) NOT NULLForm ID
RPT_RQST_DTTMDateTime(26)TIMESTAMPReport Request Datetime
RPT_DELIVERY_DTTMDateTime(26)TIMESTAMPReport Delivery Datetime
ROLEUSERCharacter(30)VARCHAR2(30) NOT NULLRole User
RPT_DELIVERY_STATCharacter(1)VARCHAR2(1) NOT NULLReport Delivery Status
D=Delivered
P=Pending Delivery
REPORT_FILENAMECharacter(80)VARCHAR2(80) NOT NULLAttachment
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
MASS_REPORT_IDCharacter(30)VARCHAR2(30) NOT NULLMass Report ID
MASS_REPORT_SEQNumber(6,0)INTEGER NOT NULLMass Report Sequence
RC_RECNAMECharacter(15)VARCHAR2(15) NOT NULLRun Control Recname
RPT_PARM1Character(50)VARCHAR2(50) NOT NULLReport Parm 1
RPT_PARM2Character(50)VARCHAR2(50) NOT NULLReport Parm 2
RPT_PARM3Character(50)VARCHAR2(50) NOT NULLReport Parm 3
RPT_PARM4Character(50)VARCHAR2(50) NOT NULLReport Parm 4
RPT_PARM5Character(50)VARCHAR2(50) NOT NULLReport Parm 5
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19