GPSC_SSB_BANK(SQL Table) |
Index Back |
|---|---|
Banking Setup TableSetup Record - Banking Main Setup Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GPSC_SSB_CNT_VW |
|
| 2 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | GPSC_SSB_AC_ALLOW | Character(2) | VARCHAR2(2) NOT NULL |
Allow others countries different to Pay Entity country the employee belongs.
AC=Any Country HM=Home Country Only SC=Specified Countries Default Value: HM |
| 5 | GPSC_SSB_ATACH_ENB | Character(1) | VARCHAR2(1) NOT NULL |
Enable Attachments
Y/N Table Edit Default Value: N |
| 6 | GPSC_SSB_ATACH_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Attachment Required
Y/N Table Edit Default Value: N |
| 7 | GPSC_SSB_NTF_ENB | Character(1) | VARCHAR2(1) NOT NULL |
Enable Notification Option.
Y/N Table Edit Default Value: N |
| 8 | GPSC_SSB_NOTFY_EMP | Character(1) | VARCHAR2(1) NOT NULL |
Notify Employee
Y/N Table Edit Default Value: N |
| 9 | GPSC_SSB_NOTFY_ADM | Character(1) | VARCHAR2(1) NOT NULL |
Notify Admin
Y/N Table Edit Default Value: N |
| 10 | GPSC_SSB_RETYPE_AC | Character(1) | VARCHAR2(1) NOT NULL |
Retype Account Option.
Y/N Table Edit Default Value: N |
| 11 | GPSC_SSB_MASK_ENB | Character(1) | VARCHAR2(1) NOT NULL |
Enable Mask Option.
Y/N Table Edit Default Value: N |
| 12 | GPSC_SSB_ONE_ACC | Character(1) | VARCHAR2(1) NOT NULL |
Single Bank Account.
Y/N Table Edit |