PTUALTRECFLDDAT

index back

Alter Analyzer

Alter Analyzer

PeopleSoft Field Name Field Type Column Type Description
PTUPG_SRECNAME Character(15) VARCHAR2(15) NOT NULL Source Record Name
PTUPG_SRECTYPE Number(3,0) SMALLINT NOT NULL Source Record Type
PTUPG_SFLDNAME Character(18) VARCHAR2(18) NOT NULL Source Field Name
PTUPG_SFLDTYPE Number(3,0) SMALLINT NOT NULL Source Field Type
PTUPG_SFLDLEN Number(3,0) SMALLINT NOT NULL Source Field Length
PTUPG_SFLDDECPOS Number(3,0) SMALLINT NOT NULL Source Field Decimal Position
PTUPG_SFLDNOTNULL Number(3,0) SMALLINT NOT NULL Source Field Nullability
PTUPG_SFLDDEFREC Character(15) VARCHAR2(15) NOT NULL Source Field Default Record Na
PTUPG_SFLDDEFFLD Character(18) VARCHAR2(18) NOT NULL Source Field Default Field Nam
PTUPG_SENCRYPT Number(3,0) SMALLINT NOT NULL Source Field Encryption
PTUPG_TRECNAME Character(15) VARCHAR2(15) NOT NULL Target Record Name
PTUPG_TRECTYPE Number(3,0) SMALLINT NOT NULL Target Record Type
PTUPG_TFLDNAME Character(18) VARCHAR2(18) NOT NULL Target Field Name
PTUPG_TFLDTYPE Number(3,0) SMALLINT NOT NULL Target Field Type
PTUPG_TFLDLEN Number(3,0) SMALLINT NOT NULL Target Field Length
PTUPG_TFLDDECPOS Number(3,0) SMALLINT NOT NULL Target Field Decimal Position
PTUPG_TFLDNOTNULL Number(3,0) SMALLINT NOT NULL Target Field Nullability
PTUPG_TFLDDEFREC Character(15) VARCHAR2(15) NOT NULL Target Field Default Record Na
PTUPG_TFLDDEFFLD Character(18) VARCHAR2(18) NOT NULL Target Field Default Field Nam
PTUPG_TENCRYPT Number(3,0) SMALLINT NOT NULL Target Field Encryption
PTUPG_ALTACT_A Number(3,0) SMALLINT NOT NULL Alter Action Add
PTUPG_ALTACT_D Number(3,0) SMALLINT NOT NULL Alter Action Delete
PTUPG_ALTACT_CT Number(3,0) SMALLINT NOT NULL Alter Action Change Field Type
PTUPG_ALTACT_CL Number(3,0) SMALLINT NOT NULL Alter Action Field Length
PTUPG_ALTACT_CD Number(3,0) SMALLINT NOT NULL Alter Action Field Decimal
PTUPG_ALTACT_CN Number(3,0) SMALLINT NOT NULL Alter Action Field Nullability
PTUPG_ALTACT_CDR Number(3,0) SMALLINT NOT NULL Alter Action Default Record
PTUPG_ALTACT_CDF Number(3,0) SMALLINT NOT NULL Alter Action Default Field
PTUPG_ALTACT_CEN Number(3,0) SMALLINT NOT NULL Alter Action Encryption Change
PTUPG_ALTACT_FR Number(3,0) SMALLINT NOT NULL Alter Action Field Rename
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19