PSMSF_AET

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
DISCOBJECTID1Character(50)VARCHAR2(50) NOT NULLDisconnected Object ID 1
DISCOBJECTID2Character(50)VARCHAR2(50) NOT NULLDisconnected Object ID 2
DISCOBJECTID3Character(50)VARCHAR2(50) NOT NULLDisconnected Object ID 3
SEQUENCENONumber(10,0)DECIMAL(10) NOT NULLSequence Number
PARENTFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name
PARENTRECNAMECharacter(15)VARCHAR2(15) NOT NULLParent Record Name
DBIDCharacter(32)VARCHAR2(32) NOT NULLDBID
PTNEXTVALUENumber(9,0)DECIMAL(9) NOT NULLPeopleTools Next Value
PTMAXVALUENumber(9,0)DECIMAL(9) NOT NULLPeopleTools Max Value
CURAVAILNumber(4,0)SMALLINT NOT NULLCurrent Available
NEWASSIGNEDNumber(9,0)DECIMAL(9) NOT NULLNewely Assigned
ACTIVEFLAGNumber(1,0)SMALLINT NOT NULLIndex Active
ISCOMPLETEDNumber(1,0)SMALLINT NOT NULLIS Completed
WHERE_CLAUSELong Character(500)VARCHAR2(500)Where Clause
NEWIDSSigned Number(27,0)DECIMAL(26) NOT NULLNEW IDS
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
PTNEXTSYSTEMIDNumber(9,0)DECIMAL(9) NOT NULLPeopleTools Next SystemID
PTUPDSYSTEMIDNumber(9,0)DECIMAL(9) NOT NULLPeopletools Update System ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19