INSTALLATION_BN(SQL Table) |
Index Back |
|---|---|
Benefits Installation tableBenefits Installation table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RETRODED_SEQ_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Retroded Request Seq. No. |
| 2 | FSA_CLAIM_NBR_LAST | Number(8,0) | INTEGER NOT NULL | Last FSA Claim Nbr Assigned |
| 3 | FSA_CRY_CLAIM_LAST | Number(8,0) | INTEGER NOT NULL | Last Cdn FSA CryFwd Claim Nbr |
| 4 | COBRA_EMPLID_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last COBRA Emplid Assigned |
| 5 | MIN_FEHB_HRS | Number(7,2) | DECIMAL(6,2) NOT NULL |
Minimum hours for temporary/intermittant/seasonal employees in Federal Employees Health Benefits (FEHB) Program.
Default Value: 16 |
| 6 | MAX_FEHB_HRS | Number(7,2) | DECIMAL(6,2) NOT NULL |
Maximum hours for temporary/intermittant/seasonal employees in Federal Employees Health Benefits (FEHB) Program.
Default Value: 32 |
| 7 | BNE_CARD_SUMM_BTN | Character(1) | VARCHAR2(1) NOT NULL |
Submit and Preview
1=Enrollment Summary Section 2=Upper right side of the page 3=Bottom of the page Default Value: 1 |
| 8 | BNE_CARD_SUMM_BTT | Character(1) | VARCHAR2(1) NOT NULL |
Back to Top
1=Do not display 2=Dynamically at the bottom Default Value: 1 |