RPT_RQST

index back

Report Request Table


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

Default: P

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

Prompt Table: RPT_PRCSDEFN_VW

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