BAS_STMT_SETUP(SQL Table) |
Index Back |
|---|---|
Benefits Statement OptionsStatement options for confirmation and enrollment statements |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BAS_STMT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Benefits Statement Type
C=Confirmation Statement E=Enrollment Preview S=Submitted Enrollment |
| 2 | SCHED_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Schedule ID
Prompt Table: BAS_SCHED |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
Prompt Table: PSXPRPTDEFN |
| 5 | REPORT_DEFN_ID1 | Character(12) | VARCHAR2(12) NOT NULL |
Report Name
Prompt Table: PSXPRPTDEFN |
| 6 | BAS_NUM_EMPLOYEES | Number(6,0) | INTEGER NOT NULL | Number of employees per file |
| 7 | BAS_AVAIL_SS | Character(1) | VARCHAR2(1) NOT NULL |
Available in Self Service
Y/N Table Edit Default Value: N |
| 8 | BAS_EMAIL_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Send Email Notifications?
Y/N Table Edit Default Value: N |
| 9 | BAS_TMPL_DEF_ID | Character(4) | VARCHAR2(4) NOT NULL |
Template Definition ID
Prompt Table: BAS_STM_TM_DEVW |