PSMSF_AET

index back

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
DISCOBJECTID1 Character(50) VARCHAR2(50) NOT NULL Disconnected Object ID 1
DISCOBJECTID2 Character(50) VARCHAR2(50) NOT NULL Disconnected Object ID 2
DISCOBJECTID3 Character(50) VARCHAR2(50) NOT NULL Disconnected Object ID 3
SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
PARENTFIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name
DBID Character(32) VARCHAR2(32) NOT NULL DBID
PTNEXTVALUE Number(9,0) DECIMAL(9) NOT NULL PeopleTools Next Value
PTMAXVALUE Number(9,0) DECIMAL(9) NOT NULL PeopleTools Max Value
CURAVAIL Number(4,0) SMALLINT NOT NULL Current Available
NEWASSIGNED Number(9,0) DECIMAL(9) NOT NULL Newely Assigned
ACTIVEFLAG Number(1,0) SMALLINT NOT NULL Index Active
ISCOMPLETED Number(1,0) SMALLINT NOT NULL IS Completed
WHERE_CLAUSE Long Character(500) VARCHAR2(500) Where Clause
NEWIDS Signed Number(27,0) DECIMAL(26) NOT NULL NEW IDS
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
PTNEXTSYSTEMID Number(9,0) DECIMAL(9) NOT NULL PeopleTools Next SystemID
PTUPDSYSTEMID Number(9,0) DECIMAL(9) NOT NULL Peopletools Update System ID
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19