NVS_REPORT

index back

PS/nVision Report Requests


  • Related language record: NVS_REPORT_LANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    BUSINESS_UNITCharacter(5)VARCHAR2(5) NOT NULLBusiness Unit

    Prompt Table: %EDITTABLE

    REPORT_IDCharacter(8)VARCHAR2(8) NOT NULLReport Identifier
    PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name

    Prompt Table: PRCSDEFNFLDR_VW
    Set Control Field: PSRF_FOLDER_NAME

    LAYOUT_IDCharacter(50)VARCHAR2(50) NOT NULLnVision Layout
    REPORT_SCOPECharacter(10)VARCHAR2(10) NOT NULLReport Scope

    Prompt Table: NVS_SCOPE

    NVS_DIR_TEMPLATECharacter(254)VARCHAR2(254) NOT NULLDirectory Name Template
    NVS_DOC_TEMPLATECharacter(254)VARCHAR2(254) NOT NULLFile Template
    OVERRIDE_LAYOUTCharacter(1)VARCHAR2(1) NOT NULLOverride Layout

    Y/N Table Edit

    Default: Y

    NVS_LANG_TEMPLATECharacter(50)VARCHAR2(50) NOT NULLLanguage Template
    NVS_EMAIL_TEMPLATECharacter(254)VARCHAR2(254) NOT NULLEmail Template
    NVS_DESCR_TEMPLATECharacter(254)VARCHAR2(254) NOT NULLContent Description Template
    NVS_AUTH_TEMPLATECharacter(254)VARCHAR2(254) NOT NULLSecurity Template
    OUTDESTTYPECharacter(3)VARCHAR2(3) NOT NULLProcess 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

    OUTDESTFORMATCharacter(3)VARCHAR2(3) NOT NULLProcess 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_ONLYCharacter(1)VARCHAR2(1) NOT NULLData From Requesting B.U. Only

    Y/N Table Edit

    Default: Y

    NPLODE_DETAILSCharacter(1)VARCHAR2(1) NOT NULLnPlode to Underlying Details

    Y/N Table Edit

    Default: Y

    TRANSLATE_LEDGERSCharacter(1)VARCHAR2(1) NOT NULLTranslate Summ Ledgers to Dtl

    Y/N Table Edit

    Default: N

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    EFFDT_OPTNCharacter(1)VARCHAR2(1) NOT NULLTree As Of Date
    D=Default
    R=Use As Of Reporting Date
    U=Specify

    Default: R

    TREE_EFFDTDate(10)DATEEffective date of the Tree
    AS_OF_DATEDate(10)DATEAs of Date
    AS_OF_DT_OPTIONCharacter(1)VARCHAR2(1) NOT NULLAs Of Reporting Date
    D=Default
    R=Business Unit Reporting Date
    T=Today's Date
    U=Specify

    Default: T

    REQUEST_URILong Character(1024)VARCHAR2(1024)Request URL
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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_AMODECharacter(1)VARCHAR2(1) NOT NULLReport Request Access Mode
    P=Public
    S=Secured

    Default: S

    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    TIMEOUTMINUTESNumber(5,0)INTEGER NOT NULLTime out minutes

    Default: 0

    PT_RETENTIONDAYSNumber(4,0)SMALLINT NOT NULLRetention Days

    Default: 0

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