EMPLIDPrompt Table: PERSON
BILL_ADJ_IDPOSTING_DATEDefault Value: %date
POSTING_SEQUENCEPrompt Table: BEN_BI_CALENDAR
Default Value: %date
CHG=Charge Adjustment
PAY=Payment Adjustment
Default Value: CHG
BEN_BI_ADJSTMNT(SQL Table) |
Index Back |
|---|---|
AdjustmentsBEN_BI_ADJSTMNT holds information about adjustments. This table has equivalent status with BEN_BI_CHARGE and BEN_BI_PAYMENT. These three tables together hold all the information on accounting entries and are joined through BEN_BI_DETAIL. This table is never updated directly on panels. It is updated through SQLExec Insert statements using fields on DERIVED_BEN_BI as the input source. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | BILL_ADJ_ID |
Signed Number(8,0) | DECIMAL(7) NOT NULL | Billing Adjustment ID |
| 3 | POSTING_DATE |
Date(10) | DATE |
Posting Date
Default Value: %date |
| 4 | POSTING_SEQUENCE |
Number(2,0) | SMALLINT NOT NULL | Posting Sequence |
| 5 | BILL_CHARGE_ID | Number(7,0) | INTEGER NOT NULL | Billing Charge ID |
| 6 | BILL_PAY_ID | Number(7,0) | INTEGER NOT NULL | Payment ID |
| 7 | NET_ADJUSTMENT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Net Adjustment |
| 8 | PRINT_PERIOD | Character(4) | VARCHAR2(4) NOT NULL |
Print Period
Prompt Table: BEN_BI_CALENDAR |
| 9 | ADJ_ENTRY_DT | Date(10) | DATE |
Adjustment Entry Date
Default Value: %date |
| 10 | ADJUST_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Adjustment Type
CHG=Charge Adjustment PAY=Payment Adjustment Default Value: CHG |
| 11 | ADJ_DESCR | Character(250) | VARCHAR2(250) NOT NULL | Adjustment Description |