PSPTANALYSISAET

index back

State Record for PSPTANALYSIS

State record for AE program PSPTANALYSIS

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
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_COMPTYPE Character(1) VARCHAR2(1) NOT NULL Compare Type
D=To Database
F=From File
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
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).
FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
EFFDT Date(10) DATE Effective Date

Default: %date

PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
PTTST_CMD_ID Number(5,0) INTEGER NOT NULL Scr Command ID
NUMROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19