PSPTANALYSISAET

index back

State Record for PSPTANALYSIS

State record for AE program PSPTANALYSIS

PeopleSoft Field NameField TypeColumn TypeDescription
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
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_COMPTYPECharacter(1)VARCHAR2(1) NOT NULLCompare Type
D=To Database
F=From File
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
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).
FIELDVALUECharacter(4)VARCHAR2(4) NOT NULLField Value
EFFDTDate(10)DATEEffective Date

Default: %date

PTTST_NAMECharacter(30)VARCHAR2(30) NOT NULLTest Name (see PSPTTSTDEFN).
PTTST_CMD_IDNumber(5,0)INTEGER NOT NULLScr Command ID
NUMROWSNumber(15,0)DECIMAL(15) NOT NULLNumber of Rows fetched.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19