PSADSCMPINSTST

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PTSESSIONIDCharacter(36)VARCHAR2(36) NOT NULLCompare Session Id
PTADSNAMECharacter(30)VARCHAR2(30) NOT NULLData Set Name (see PSADSDEFN).

Prompt Table: PSADSDEFN
Set Control Field: PTADSNAME

PTADSCONTENTIDNumber(6,0)INTEGER NOT NULLADS Content Identifier
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).

Prompt Table: PSPROJECTDEFN

PTKEYHASHCharacter(28)VARCHAR2(28) NOT NULL
PTADSSOURCESTATUSNumber(1,0)SMALLINT NOT NULLSource Status
A=Added
C=Changed
D=Deleted
S=Unchanged
U=Unknown

Default: 0

PTADSPROPSTATUSNumber(1,0)SMALLINT NOT NULLProposed Status
A=Added
C=Changed
D=Deleted
S=Unchanged
U=Unknown

Default: 0

PTSRCCUSTOMIZEFLGNumber(2,0)SMALLINT NOT NULLCustom Status - Source
E=Equal to database
G=Greater than database
L=Less than database
U=Unknown

Default: 0

PTTGTCUSTOMIZEFLGNumber(2,0)SMALLINT NOT NULLCustom Status - Target
E=Equal to database
G=Greater than database
L=Less than database
U=Unknown

Default: 0

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19