SCHED_IDPrompt Table: BAS_SCHED
EMPLIDPrompt Table: PERSON
OPRIDBENEFIT_RCD_NBREVENT_IDPrompt Table: BEN_DEFN_PGM
W3EB_PARTC_SRCH(SQL View) |
Index Back |
|---|---|
BAS Partic: Inquiry- & SearchBAS_PAR_VW is a view of the BAS_PARTIC table without any PeopleCode. It is used in Inquiry and Search processes. |
| SELECT P.SCHED_ID , P.EMPLID , O.OPRID ,P.BENEFIT_RCD_NBR ,P.EVENT_ID ,P.BENEFIT_PROGRAM ,P.EVENT_DT FROM PS_BAS_PARTIC P , PSOPRDEFN O WHERE P.EMPLID = O.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCHED_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Schedule ID
Prompt Table: BAS_SCHED |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | 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. |
| 5 | EVENT_ID |
Number(6,0) | INTEGER NOT NULL | Event Identification |
| 6 | BENEFIT_PROGRAM | Character(3) | VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
Prompt Table: BEN_DEFN_PGM |
| 7 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |