BEN_Q_PRELER_VW(SQL View) |
Index Back |
|---|---|
Benefits Workcenter QueryBenefits Workcenter Query to find overage dependents |
| SELECT A.EMPLID , B.NAME , A.BENEFIT_RCD_NBR , A.SCHED_ID , A.EVENT_ID , A.OPTION_ID , A.COST_ID , A.MSGID , C.DESCRLONG , A.MSGDATA1 , A.MSGDATA2 , A.MSGDATA3 , S.OPRID FROM PS_BAS_MESSAGE A , PS_PERSON_NAME B , PS_PAY_MESSAGE_TBL C , PS_PERS_SRCH_GBL S WHERE B.EMPLID = A.EMPLID AND C.MSGID = A.MSGID AND S.EMPLID = A.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 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 | SCHED_ID | Character(6) | VARCHAR2(6) NOT NULL | Schedule ID |
| 5 | EVENT_ID | Number(6,0) | INTEGER NOT NULL | Event Identification |
| 6 | OPTION_ID | Number(4,0) | SMALLINT NOT NULL | Option ID |
| 7 | COST_ID | Number(4,0) | SMALLINT NOT NULL | Cost Identification |
| 8 | MSGID | Character(6) | VARCHAR2(6) NOT NULL | Message ID |
| 9 | DESCRLONG | Long Character | CLOB | Long Description |
| 10 | MSGDATA1 | Character(30) | VARCHAR2(30) NOT NULL | Message Data |
| 11 | MSGDATA2 | Character(30) | VARCHAR2(30) NOT NULL | Message Data 2 |
| 12 | MSGDATA3 | Character(30) | VARCHAR2(30) NOT NULL | Message Data 3 |
| 13 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |