EMPLIDPrompt Table: PERSON
CHG=Charge Adjustment
PAY=Payment Adjustment
BEN_BI_ADJST_VW(SQL View) |
Index Back |
|---|---|
Adjustment SummaryBEN_BI_ADJST_VW presents information about adjustments on the Adjustment summary panel. |
| SELECT EMPLID ,POSTING_DATE ,ADJUST_TYPE ,NET_ADJUSTMENT ,ADJ_DESCR FROM PS_BEN_BI_ADJSTMNT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | POSTING_DATE | Date(10) | DATE | Posting Date |
| 3 | ADJUST_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Adjustment Type
CHG=Charge Adjustment PAY=Payment Adjustment |
| 4 | NET_ADJUSTMENT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Net Adjustment |
| 5 | ADJ_DESCR | Character(250) | VARCHAR2(250) NOT NULL | Adjustment Description |