PSPTTSTMAINTRPT

index back

PTF Test Maintenance Rpt Data

PTF Test Maintenance - Report (or Grid) Data

PeopleSoft Field NameField TypeColumn TypeDescription
USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
RUNDTTMDateTime(26)TIMESTAMPRun Date/Time
GUIDCharacter(36)VARCHAR2(36) NOT NULLUnique Identifier
PTTST_ANALYSISNBRNumber(5,0)INTEGER NOT NULLSequence Number
DTTM_STAMPDateTime(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.
PTTST_NAMECharacter(30)VARCHAR2(30) NOT NULLTest Name (see PSPTTSTDEFN).
PTTST_ANALYSISCATCharacter(4)VARCHAR2(4) NOT NULLAnalysis Category
PTTST_ANALYSISPRICharacter(1)VARCHAR2(1) NOT NULLPriority
1=1 - High
2=2 - Medium
3=3 - Low
4=4 - Ignore
PTTST_CMD_IDNumber(5,0)INTEGER NOT NULLScr Command ID
PTTST_LANG_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code
SEQNBRNumber(5,0)INTEGER NOT NULLSequence Number
PTTST_CMD_STATUSCharacter(1)VARCHAR2(1) NOT NULLCMD Status
A=Active
I=Inactive
N=No Data
X=N/A
PTTST_OBJECTTYPENumber(5,0)INTEGER NOT NULLObject Type
PTTST_OBJECTDESCCharacter(50)VARCHAR2(50) NOT NULLObject
PTTST_OBJECTNAMECharacter(50)VARCHAR2(50) NOT NULLObject Name
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
PTTST_OBJECTACTIONCharacter(1)VARCHAR2(1) NOT NULLObject Action
A=Added
C=Changed
D=Deleted
PTTST_PREOBJVALUECharacter(92)VARCHAR2(92) NOT NULLPre Object Value
PTTST_POSTOBJVALUECharacter(92)VARCHAR2(92) NOT NULLPost Object Value
PTTST_DESCRCharacter(254)VARCHAR2(254) NOT NULLDescription
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19