GPIT_DM10_RUNCL(SQL Table) |
Index Back |
---|---|
DM10 Run ControlDM10: 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 |