PSNVSBOOK

index back

PS/nVision Report Book


PeopleSoft Field Name Field Type Column Type Description
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
REQUEST_URI Long Character(1024) VARCHAR2(1024) Request URL
AS_OF_DT_OPTION Character(1) VARCHAR2(1) NOT NULL As Of Reporting Date
D=Default
R=Business Unit Reporting Date
T=Today's Date
U=Specify

Default: T

AS_OF_DATE Date(10) DATE As of Date

Default: %date

EFFDT_OPTN Character(1) VARCHAR2(1) NOT NULL Tree As Of Date
D=Default
R=Use As Of Reporting Date
U=Specify

Default: R

TREE_EFFDT Date(10) DATE Effective date of the Tree

Default: %date

IGNORE_ERRORS Character(1) VARCHAR2(1) NOT NULL Ignore Errors

Y/N Table Edit

Default: Y

PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days

Default: 0

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20