BAS_STM_TM_PERS(SQL Table) |
Index Back |
---|---|
Statement Template Personal |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(4) | VARCHAR2(4) NOT NULL | Template Definition ID | |
2 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
3 | Character(1) | VARCHAR2(1) NOT NULL |
Personal Information Section Fields
A=Mailing Address B=Email Address C=Home Address D=Gender E=Marital Status F=Birth Date G=Service Date |
|
4 | BAS_TMPL_PEOP_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Personal Information Fields Option
Y/N Table Edit |