PSPTANALYSISDTL

index back

Analysis Details


PeopleSoft Field NameField TypeColumn TypeDescription
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
GUIDCharacter(36)VARCHAR2(36) NOT NULLUnique Identifier
PTTST_ANALYSISNBRNumber(5,0)INTEGER NOT NULLSequence Number
RUNDTTMDateTime(26)TIMESTAMPRun Date/Time
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_ANALYSISTYPECharacter(4)VARCHAR2(4) NOT NULLAnalysis Type
A=Attribute
O=Object
PTTST_ANALYSISCATCharacter(4)VARCHAR2(4) NOT NULLAnalysis Category
PTTST_OBJECTTYPENumber(5,0)INTEGER NOT NULLObject Type
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_PRE_OBJ1Character(30)VARCHAR2(30) NOT NULLPre Object 1
PTTST_PRE_OBJ2Character(30)VARCHAR2(30) NOT NULLPre Object 2
PTTST_PRE_OBJ3Character(30)VARCHAR2(30) NOT NULLPre Object 3
PTTST_POST_OBJ1Character(30)VARCHAR2(30) NOT NULLPost Object 1
PTTST_POST_OBJ2Character(30)VARCHAR2(30) NOT NULLPost Object 2
PTTST_POST_OBJ3Character(30)VARCHAR2(30) NOT NULLPost Object 3
PTTST_DESCRCharacter(254)VARCHAR2(254) NOT NULLDescription
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19