BENEFIT_PLANPROC_SEQ_NUMEFFDTDefault Value: %date
FUNCTN_NAMEFUNCTN_SEQ_NUMFLD_SEQ_NUMPA_TEMP3(SQL Table) |
Index Back |
|---|
| # | 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
Default Value: %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 |