NVS_REPORT

index back

PS/nVision Report Requests


  • Related language record: NVS_REPORT_LANG
  • PeopleSoft Field Name Field Type Column Type Description
    BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: %EDITTABLE

    REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
    PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name

    Prompt Table: PRCSDEFNFLDR_VW
    Set Control Field: PSRF_FOLDER_NAME

    LAYOUT_ID Character(50) VARCHAR2(50) NOT NULL nVision Layout
    REPORT_SCOPE Character(10) VARCHAR2(10) NOT NULL Report Scope

    Prompt Table: NVS_SCOPE

    NVS_DIR_TEMPLATE Character(254) VARCHAR2(254) NOT NULL Directory Name Template
    NVS_DOC_TEMPLATE Character(254) VARCHAR2(254) NOT NULL File Template
    OVERRIDE_LAYOUT Character(1) VARCHAR2(1) NOT NULL Override Layout

    Y/N Table Edit

    Default: Y

    NVS_LANG_TEMPLATE Character(50) VARCHAR2(50) NOT NULL Language Template
    NVS_EMAIL_TEMPLATE Character(254) VARCHAR2(254) NOT NULL Email Template
    NVS_DESCR_TEMPLATE Character(254) VARCHAR2(254) NOT NULL Content Description Template
    NVS_AUTH_TEMPLATE Character(254) VARCHAR2(254) NOT NULL Security Template
    OUTDESTTYPE Character(3) VARCHAR2(3) NOT NULL Process Request output destination type.
    0=Any
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default
    8=Feed
    9=IB Node

    Default: 6

    Prompt Table: NVS_OUTTYPE_VW

    OUTDESTFORMAT Character(3) VARCHAR2(3) NOT NULL Process Request output format
    0=Any
    1=(None)
    10=Postscript (*.lis)
    11=Crystal Report (*.rpt)
    12=Rich Text File (*.rtf)
    13=SQR Portable Format (*.spf)
    14=Text Files (*.txt)
    15=Other
    16=Default
    17=XML Format(*.xml)
    18=Data Mover Data File (*.dat)
    19=Crystal Report Explorer(*.rpt)
    2=Acrobat (*.pdf)
    20=XMLP
    21=Atom
    22=Transformation
    23=Printer Command Lang. (*.pcl)
    24=PostScript (*.ps)
    3=Comma delimited (*.csv)
    4=HP Format (*.lis)
    5=HTML Documents (*.htm)
    6=Line Printer Format (*.lis)
    7=Lotus 1-2-3 Files (*.wks)
    8=Microsoft Excel Files (*.xls)
    9=Microsoft Word (*.doc)

    Default: 8

    Prompt Table: NVS_OUTFORM_VW

    REQ_BU_ONLY Character(1) VARCHAR2(1) NOT NULL Data From Requesting B.U. Only

    Y/N Table Edit

    Default: Y

    NPLODE_DETAILS Character(1) VARCHAR2(1) NOT NULL nPlode to Underlying Details

    Y/N Table Edit

    Default: Y

    TRANSLATE_LEDGERS Character(1) VARCHAR2(1) NOT NULL Translate Summ Ledgers to Dtl

    Y/N Table Edit

    Default: N

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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
    AS_OF_DATE Date(10) DATE As of Date
    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

    REQUEST_URI Long Character(1024) VARCHAR2(1024) Request URL
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    NVS_REPRQST_AMODE Character(1) VARCHAR2(1) NOT NULL Report Request Access Mode
    P=Public
    S=Secured

    Default: S

    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    TIMEOUTMINUTES Number(5,0) INTEGER NOT NULL Time out minutes

    Default: 0

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

    Default: 0

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19