BENEFIT_PLANPROC_SEQ_NUMEFFDTFUNCTN_NAMEFUNCTN_SEQ_NUMFLD_SEQ_NUMPA_PROC_U_FLD_1(SQL Table) |
Index Back |
|---|---|
Plan ImplementationThis is a setup table for Plan Implementation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 2 | PROC_SEQ_NUM |
Number(4,0) | SMALLINT NOT NULL | Auto Process Sequence |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | FUNCTN_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Function Name |
| 5 | FUNCTN_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Function Sequence Number |
| 6 | FLD_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Field Sequence Number |
| 7 | FLD_NAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 8 | FLD_PICTURE | Character(10) | VARCHAR2(10) NOT NULL | Picture Format |
| 9 | FLD_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Field Type |
| 10 | FLD_CODE | Character(1) | VARCHAR2(1) NOT NULL | Field Code |