BNE_COMP_LST_VW(SQL View) |
Index Back |
|---|
| SELECT ' ' , 0 ,' ' ,' ' ,' ' ,' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BNE_COMPPLAN_DESCR | Long Character(250) | VARCHAR2(250) | Benefit Plan |
| 2 | COST_TOTAL | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Cost Total |
| 3 | SELECTED | Character(1) | VARCHAR2(1) NOT NULL | Selected |
| 4 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 5 | COVRG_CD | Character(2) | VARCHAR2(2) NOT NULL | Coverage Code |
| 6 | BNE_COMPARE_CHKBX | Character(1) | VARCHAR2(1) NOT NULL |
Select for compare checkbox
N=No Y=Yes Default Value: N |