SYNCIDGEN_CNTL

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 ONLYSETINVALIDID Number(1,0) SMALLINT NOT NULL Reset All Sync IDs

Default Value: 0

4 RESETSYNCIDTYPE Character(1) VARCHAR2(1) NOT NULL Reset Sync ID For
A=Reset All Table
P=Reset By Project
R=Reset By Record

Default Value: A

5 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).

Prompt Table: SYNCPROJ_VW

6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: SYNCREC_VW