PSPTTSTMAINTRPT

index back

PTF Test Maintenance Rpt Data

PTF Test Maintenance - Report (or Grid) Data

PeopleSoft Field Name Field Type Column Type Description
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
PTTST_ANALYSISNBR Number(5,0) INTEGER NOT NULL Sequence Number
DTTM_STAMP 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.
PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
PTTST_ANALYSISCAT Character(4) VARCHAR2(4) NOT NULL Analysis Category
PTTST_ANALYSISPRI Character(1) VARCHAR2(1) NOT NULL Priority
1=1 - High
2=2 - Medium
3=3 - Low
4=4 - Ignore
PTTST_CMD_ID Number(5,0) INTEGER NOT NULL Scr Command ID
PTTST_LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
PTTST_CMD_STATUS Character(1) VARCHAR2(1) NOT NULL CMD Status
A=Active
I=Inactive
N=No Data
X=N/A
PTTST_OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
PTTST_OBJECTDESC Character(50) VARCHAR2(50) NOT NULL Object
PTTST_OBJECTNAME Character(50) VARCHAR2(50) NOT NULL Object Name
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
PTTST_OBJECTACTION Character(1) VARCHAR2(1) NOT NULL Object Action
A=Added
C=Changed
D=Deleted
PTTST_PREOBJVALUE Character(92) VARCHAR2(92) NOT NULL Pre Object Value
PTTST_POSTOBJVALUE Character(92) VARCHAR2(92) NOT NULL Post Object Value
PTTST_DESCR Character(254) VARCHAR2(254) NOT NULL Description
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19