PSADSCMPINSTST

index back

PeopleSoft Field Name Field Type Column Type Description
PTSESSIONID Character(36) VARCHAR2(36) NOT NULL Compare Session Id
PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).

Prompt Table: PSADSDEFN
Set Control Field: PTADSNAME

PTADSCONTENTID Number(6,0) INTEGER NOT NULL ADS Content Identifier
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).

Prompt Table: PSPROJECTDEFN

PTKEYHASH Character(28) VARCHAR2(28) NOT NULL
PTADSSOURCESTATUS Number(1,0) SMALLINT NOT NULL Source Status
A=Added
C=Changed
D=Deleted
S=Unchanged
U=Unknown

Default: 0

PTADSPROPSTATUS Number(1,0) SMALLINT NOT NULL Proposed Status
A=Added
C=Changed
D=Deleted
S=Unchanged
U=Unknown

Default: 0

PTSRCCUSTOMIZEFLG Number(2,0) SMALLINT NOT NULL Custom Status - Source
E=Equal to database
G=Greater than database
L=Less than database
U=Unknown

Default: 0

PTTGTCUSTOMIZEFLG Number(2,0) SMALLINT NOT NULL Custom Status - Target
E=Equal to database
G=Greater than database
L=Less than database
U=Unknown

Default: 0

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20