PTUALTRECFLDDAT

index back

Alter Analyzer

Alter Analyzer

PeopleSoft Field NameField TypeColumn TypeDescription
PTUPG_SRECNAMECharacter(15)VARCHAR2(15) NOT NULLSource Record Name
PTUPG_SRECTYPENumber(3,0)SMALLINT NOT NULLSource Record Type
PTUPG_SFLDNAMECharacter(18)VARCHAR2(18) NOT NULLSource Field Name
PTUPG_SFLDTYPENumber(3,0)SMALLINT NOT NULLSource Field Type
PTUPG_SFLDLENNumber(3,0)SMALLINT NOT NULLSource Field Length
PTUPG_SFLDDECPOSNumber(3,0)SMALLINT NOT NULLSource Field Decimal Position
PTUPG_SFLDNOTNULLNumber(3,0)SMALLINT NOT NULLSource Field Nullability
PTUPG_SFLDDEFRECCharacter(15)VARCHAR2(15) NOT NULLSource Field Default Record Na
PTUPG_SFLDDEFFLDCharacter(18)VARCHAR2(18) NOT NULLSource Field Default Field Nam
PTUPG_SENCRYPTNumber(3,0)SMALLINT NOT NULLSource Field Encryption
PTUPG_TRECNAMECharacter(15)VARCHAR2(15) NOT NULLTarget Record Name
PTUPG_TRECTYPENumber(3,0)SMALLINT NOT NULLTarget Record Type
PTUPG_TFLDNAMECharacter(18)VARCHAR2(18) NOT NULLTarget Field Name
PTUPG_TFLDTYPENumber(3,0)SMALLINT NOT NULLTarget Field Type
PTUPG_TFLDLENNumber(3,0)SMALLINT NOT NULLTarget Field Length
PTUPG_TFLDDECPOSNumber(3,0)SMALLINT NOT NULLTarget Field Decimal Position
PTUPG_TFLDNOTNULLNumber(3,0)SMALLINT NOT NULLTarget Field Nullability
PTUPG_TFLDDEFRECCharacter(15)VARCHAR2(15) NOT NULLTarget Field Default Record Na
PTUPG_TFLDDEFFLDCharacter(18)VARCHAR2(18) NOT NULLTarget Field Default Field Nam
PTUPG_TENCRYPTNumber(3,0)SMALLINT NOT NULLTarget Field Encryption
PTUPG_ALTACT_ANumber(3,0)SMALLINT NOT NULLAlter Action Add
PTUPG_ALTACT_DNumber(3,0)SMALLINT NOT NULLAlter Action Delete
PTUPG_ALTACT_CTNumber(3,0)SMALLINT NOT NULLAlter Action Change Field Type
PTUPG_ALTACT_CLNumber(3,0)SMALLINT NOT NULLAlter Action Field Length
PTUPG_ALTACT_CDNumber(3,0)SMALLINT NOT NULLAlter Action Field Decimal
PTUPG_ALTACT_CNNumber(3,0)SMALLINT NOT NULLAlter Action Field Nullability
PTUPG_ALTACT_CDRNumber(3,0)SMALLINT NOT NULLAlter Action Default Record
PTUPG_ALTACT_CDFNumber(3,0)SMALLINT NOT NULLAlter Action Default Field
PTUPG_ALTACT_CENNumber(3,0)SMALLINT NOT NULLAlter Action Encryption Change
PTUPG_ALTACT_FRNumber(3,0)SMALLINT NOT NULLAlter Action Field Rename
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19