| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SCHED_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Schedule ID
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
BENEFIT_RCD_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
|
| 4 |
EVENT_ID |
Number(6,0) |
INTEGER NOT NULL |
Event Identification
|
| 5 |
ADDR_EFFDT |
Date(10) |
DATE |
Address Effective Date
|
| 6 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 7 |
JOB_EFFDT |
Date(10) |
DATE NOT NULL |
Job Effective Date
|
| 8 |
JOB_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Job Effective Sequence
|
| 9 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 10 |
EVENT_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Event Classification
|
| 11 |
EVENT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Status
C=Closed to Processing
D=Disconnected from Job Record
O=Open for Processing
V=Void
Default Value: C
|
| 12 |
BAS_PROCESS_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Process Status
AE=Program Elig Assign Error
AN=Program Elig Assign None
AS=Program Elig Assigned
EE=Election Error
ET=Entered
FA=Finalized - Benefit Pgm None
FE=Finalized - Enrolled
FP=Finalized - Prepared None
NT=Notified
PE=Prepare Error
PR=Prepared
RE=Re-Enter
|
| 13 |
PROCESS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Indicator
A=Assign Benefit Program
E=Elect Options
N=Normal Processing
P=Prepare Options
R=Re-Enter
V=Void
Default Value: N
|
| 14 |
ADDR_ELIG_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Eligibility Changed
Y/N Table Edit
Default Value: N
|
| 15 |
MJ_ELIG_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate that a change to the Primary_Jobs table was detected for this employee, which may have an impact on eligibility already processed for this event.
Y/N Table Edit
Default Value: N
|
| 16 |
JOB_ELIG_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Eligibility Changed
Y/N Table Edit
Default Value: N
|
| 17 |
BAS_EVT_DISCONNECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Disconnected
Y/N Table Edit
Default Value: N
|
| 18 |
BAS_EVENT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Out of Sequence
Y/N Table Edit
Default Value: N
|
| 19 |
ADDR_ELIG_CHG_DT |
Date(10) |
DATE |
Address Elig Changed Date
|
| 20 |
MJ_ELIG_CHG_DT |
Date(10) |
DATE |
The date that the MJ_ELIG_CHG field was set to 'Y'.
|
| 21 |
JOB_ELIG_CHG_DT |
Date(10) |
DATE |
Job Elig Changed Date
|
| 22 |
BAS_EVT_DISC_DT |
Date(10) |
DATE |
Event Disconnect Date
|
| 23 |
BAS_EVENT_CHG_DT |
Date(10) |
DATE |
Event Changed Date
|
| 24 |
FINALIZE_ENROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Finalize/Apply Defaults
Y/N Table Edit
Default Value: N
|
| 25 |
CREDIT_ROLLOVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Excess Credit Rollover To
C=Cash
D=FSA - Dependent Care
F=Forfeit Excess Credits
H=FSA - Health Care
R=FSA - Retirement Counseling
S=Savings - 401K Plan
Default Value: C
|
| 26 |
ELECT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Election Source
N=None Entered
O=Online
V=Voice Response
W=Web
Default Value: O
|
| 27 |
EVENT_EMPLRCD |
Number(3,0) |
SMALLINT NOT NULL |
Event Empl Rcd#
|
| 28 |
EVENT_DT |
Date(10) |
DATE NOT NULL |
Event Date
|
| 29 |
EVENT_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence of Event
|
| 30 |
EVENT_PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Event Priority
|
| 31 |
BAS_ACTION_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Source of Action
BP=Benefits Person
EX=Multijob Trigger Explosion
ME=Manual Event
MJ=MultiJob Indicator Change
OE=Open Enrollment
PB=Passive Event Birthdate
PS=Passive Event Service Date
SN=Snapshot
TJ=Job Data Change
TL=Union Change
TP=Address Change
|
| 32 |
MULTI_ACTIVITY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Multi-Activity Indicator
Y/N Table Edit
Default Value: N
|
| 33 |
STATUS_DT |
Date(10) |
DATE NOT NULL |
Status Date
|
| 34 |
OPTION_NOTIFY_DT |
Date(10) |
DATE |
Date Notified of Options
|
| 35 |
ELECT_RCVD_DT |
Date(10) |
DATE |
Elections Received Date
|
| 36 |
CONFIRM_NOTIFY_DT |
Date(10) |
DATE |
Date Notified of Confirmation
|
| 37 |
CONFIRM_RCVD_DT |
Date(10) |
DATE |
Confirmation Received Date
|
| 38 |
SERVICE_DT |
Date(10) |
DATE |
Service Date
|
| 39 |
COBRA_ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a COBRA-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 COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
|
| 40 |
ALLOW_SELF_SERVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Available through Self Service
N=No Self Service
X=Event Created Prior to HRMS7.5
Y=Self Service Allowed
Default Value: N
|
| 41 |
GVT_HIRE_DATE |
Date(10) |
DATE |
Hire Date
|
| 42 |
GVT_SCD_TSP |
Date(10) |
DATE |
Service Comp Date - TSP
|
| 43 |
BAS_SUPPRESS_FORMS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether or not enrollment and/or confirmation forms should be printed or suppressed for an event. This flag can be set at the event rule level or at the employee/event level.
B=Print Both Forms
C=Print Confirmation Forms Only
E=Print Enrollment Forms Only
S=Suppress Print of Both Forms
|
| 44 |
BAS_ENR_FORMS_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
This field indicates how many days prior to an event an enrollment form should be printed.
|