BN_AGE50_RUNCTL(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 | ASOFDATE | Date(10) | DATE NOT NULL | As of Date |
4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
5 | LIMIT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Limit Type
401=401(a) Limit 401G=401(a) Limit Grandfather Plan 402=402(g) Limit 403=403(b) Limit 415=415(c) Limit 415Z=415(c) Limit for 403(b) plans 457=457 Limit CH01=User Defined Per Check Limit 1 CH02=User Defined Per Check Limit 2 CH03=User Defined Per Check Limit 3 CH04=User Defined Per Check Limit 4 CH05=User Defined Per Check Limit 5 USER=User Defined Limit |
6 | ANNL_CAP_EXPN | Number(11,2) | DECIMAL(10,2) NOT NULL | Annl Cap Expsn |
7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
8 | ROTH_THRESHOLD | Character(1) | VARCHAR2(1) NOT NULL |
Over FICA Earnings Threshold for Roth Rollover
Y/N Table Edit Default Value: N |
9 | BAS_PROC_TRGR | Character(1) | VARCHAR2(1) NOT NULL |
Savings Extension Run Control to indicate BAS Activity Process
Y/N Table Edit Default Value: N |
10 | BAS_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.
Prompt Table: BAS_EVT_MANUAL |