| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BAS_TMPL_DEF_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Template Definition ID
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
BAS_TMPL_DEF_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Template Definition Name
|
| 4 |
BAS_TMPL_DEF_PEOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Personal Information Section Option
A=Always Display
N=Never Display
Default Value: A
|
| 5 |
BAS_TMPL_DEF_COOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Summary Section Option
A=Always Display
N=Never Display
Default Value: A
|
| 6 |
BAS_TMPL_DEF_ELOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Election Summary Section Option
A=Always Display
N=Never Display
Default Value: A
|
| 7 |
BAS_TMPL_DEF_ELEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Election Summary Section Exceptions
Y/N Table Edit
Default Value: N
|
| 8 |
BAS_TMPL_DEF_BEOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependents and Beneiciaries Section Option
A=Always Display
N=Never Display
O=Display only if Enrolled
Default Value: A
|
| 9 |
BAS_TMPL_DEF_ENOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependent Enrollments Section Option
A=Always Display
N=Never Display
O=Display only if Enrolled
Default Value: A
|
| 10 |
BAS_TMPL_DEF_DEOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Beneficiary Designations Section Option
A=Always Display
N=Never Display
O=Display only if Designated
Default Value: A
|
| 11 |
BAS_TMPL_DEF_INOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Investment Allocation Section Option
A=Always Display
N=Never Display
O=Display only if Allocated
Default Value: A
|