GB_GROUP_IDPrompt Table: GB_GROUP_TBL
EFFDTDefault Value: %date
EMPLIDPrompt Table: PERS_SRCH_ALL
EMPL_RCDPrompt Table: PER_ORG_ASGN
E=Exclude
I=Include
Y/N Table Edit
Default Value: N
GB_GRP_INC_EXC(SQL Table) |
Index Back |
|---|---|
Group Build OverridesGroup Build Overrides - Allows the exclusion or addition of people's jobs from/to the group build result set. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_ALL |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PER_ORG_ASGN |
| 5 | GB_INC_EXC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include/Exclude Indicator for group build overrides.
E=Exclude I=Include |
| 6 | GET_HISTORY_SW | Character(1) | VARCHAR2(1) NOT NULL |
Get History
Y/N Table Edit Default Value: N |