RQ_PRD_SUPP_ENV

(SQL Table)
Index Back

Product supported environment

Quality application added sub record 01/15/01

  • Related Language Record: RQ_PRD_SUPP_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 R_PRODUCTION_ID Character(15) VARCHAR2(15) NOT NULL Production Identification number for Quality Application
    3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    4 R_ENV_LABEL Character(30) VARCHAR2(30) NOT NULL Environment Label in Quality application
    5 R_SUPPORT_TYPE Character(4) VARCHAR2(4) NOT NULL Support Type
    MIN=Minimal
    SUP=Supported
    6 R_OS_CODE Character(4) VARCHAR2(4) NOT NULL Operating System Code
    AIX=AIX
    DOS=MS DOS
    HPUX=HP/UX
    LINX=Linux
    MAC=Macintosh
    OTHR=Other
    SUN=Solaris
    UNIX=Unix
    VMS=VMS
    W200=Windows 2000
    W31=Windows 3.1
    W95=Windows 95
    W98=Windows 98
    WNT=Windows NT
    7 R_OS_VERSION Character(15) VARCHAR2(15) NOT NULL Operating System Version
    8 R_ENVIRONMENT Character(4) VARCHAR2(4) NOT NULL Environment Identification
    DB2=DB2
    DBAS=dBASE
    INFS=Informix SE
    INFT=Informix Turbo
    MSQL=MS SQL Server
    ORAC=Oracle
    PARA=Paradox
    SANY=SQL Anywhere
    SSQL=Sybase SQL-Server
    9 R_PLATFORM_CODE Character(4) VARCHAR2(4) NOT NULL Platform code
    AS40=AS 400
    HP90=HP 9000
    MAC=Macintosh
    P286=PC 286
    P386=PC 386
    P486=PC 486
    PEN1=Pentium
    PEN2=Pentium II
    PEN3=Pentium III
    PEN4=Pentium PRO
    RS60=IBM RS6000
    SUN=SUN SPARC IPX
    VAX=VAX
    10 R_NETWORK_CODE Character(4) VARCHAR2(4) NOT NULL Network Identification
    BANY=Banyan Vines
    BNW=Beame and Whiteside
    NET1=NetWare v2.x
    NET2=NetWare v3.x
    OTCP=Other TCP/IP
    PNFS=PC-NFS
    PTCP=PC-TCP
    WTCP=Winsock TCP/IP
    11 R_UI_CODE Character(4) VARCHAR2(4) NOT NULL Defect User interface
    CHAR=Character-Based
    MAC=Macintosh
    MOTI=Motif
    OPEN=Open Look
    PMGR=Presentation Manager
    W31=Windows 3.1
    W95=Windows 95
    W98=Windows 98
    12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    15 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    16 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    18 DESCRLONG Long Character CLOB Long Description