GPIT_DM10_RUNCL

(SQL Table)
Index Back

DM10 Run Control

DM10: Report Italy...

# 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 FROMDATE Date(10) DATE From Date
4 THRUDATE Date(10) DATE End Date
5 ASOFDATE Date(10) DATE As of Date
6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPARTMENT_SRCH

8 REPORT_CHOICE Character(1) VARCHAR2(1) NOT NULL Output Report Choice
1=Applicants
2=Current Employees
3=Both Applicants and Employees
9 POPULATION Character(1) VARCHAR2(1) NOT NULL Search Population-Skill Match
1=All
2=Internal Applicants
3=External Applicants
4=Candidates for Specific Positn
10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_HR

12 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

14 PURGE_PRCS_OPTION Character(1) VARCHAR2(1) NOT NULL Purge Process Option
1=Print and Process
2=Process Only
3=Print Only

Default Value: 3

15 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

16 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP

17 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT

18 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

Prompt Table: ESTAB_TBL

19 GPIT_DM10_DECLTYPE Character(1) VARCHAR2(1) NOT NULL Declaration Type of DM10 report.
1=Active
2=Passive

Default Value: 1

20 GPIT_DM10_CRIT1 Character(1) VARCHAR2(1) NOT NULL 1.Criteria 1
C=Company
D=Deptid
E=Establishment
G=PayGroup
L=Location
P=Pay Entity
21 GPIT_DM10_CRIT2 Character(1) VARCHAR2(1) NOT NULL 2. Sort Criteria
C=Company
D=Deptid
E=Establishment
G=PayGroup
L=Location
P=Pay Entity
22 GPIT_DM10_CRIT3 Character(1) VARCHAR2(1) NOT NULL 3. Sort Criteria
C=Company
D=Deptid
E=Establishment
G=PayGroup
L=Location
P=Pay Entity