EMPLIDPrompt Table: PERSON
EMPL_RCDFP_BONUS_CDFPABONUS_VW1(SQL View) |
Index Back |
|---|---|
Employee Bonus View |
| SELECT DISTINCT B.EMPLID , B.EMPL_RCD , B.FP_BONUS_CD , B.FP_RANK_CD , B.FP_STEP_CD , B.FP_BON_END_DT FROM PS_FPABONUS_TBL B WHERE B.FP_BONUS_TYP = 'M' AND B.FP_IN_ABEYANCE <> 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | FP_BONUS_CD |
Character(6) | VARCHAR2(6) NOT NULL | Sen Bonus Code |
| 4 | FP_RANK_CD | Character(6) | VARCHAR2(6) NOT NULL | Grade |
| 5 | FP_STEP_CD | Character(4) | VARCHAR2(4) NOT NULL | Step |
| 6 | FP_BON_END_DT | Date(10) | DATE | Bonus End Date |