GPBR_RC_DIRF_A(SQL Table) | 
Index Back | 
|---|---|
Run Control DIRF Mensual MainRun Control DIRF Mensual Main Record | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | 
A user's ID (see PSOPRDEFN).
 Prompt Table: OPERATOR_VW  | 
|
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | 
Company
 Prompt Table: COMPANY_TBL  | 
| 4 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | 
Establishment ID
 Prompt Table: GPBR_ESTAB_VW  | 
| 5 | FROM_DATE | Date(10) | DATE NOT NULL | From Date | 
| 6 | THRU_DATE | Date(10) | DATE NOT NULL | Thru Date | 
| 7 | GPBR_SORTID | Character(10) | VARCHAR2(10) NOT NULL | 
SORT ID
 Prompt Table:
GPBR_SORTID
  | 
| 8 | PER_ORG | Character(3) | VARCHAR2(3) NOT NULL | 
Defines the Organizational Relationship(s) that a Person has to the Organization.  These are Employee, Contingent Worker, and Persons of Interest.
 CWR=Contingent Worker EMP=Employee POI=Person of Interest Default Value: EMP  | 
| 9 | GPBR_RC_SELECT | Character(1) | VARCHAR2(1) NOT NULL | 
Selector of parameter Run Type or Pay Group
 P=By Pay Group R=By Run Type Default Value: R  |