PY_SSP_OPTN_HDR(SQL Table) |
Index Back |
|---|---|
SSP setup option header recordPNA Self Service Paycheck setup option header record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PY_SSP_SETUP_ID |
Character(6) | VARCHAR2(6) NOT NULL | Paycheck Setup ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SUPPRESS_PYCK | Character(1) | VARCHAR2(1) NOT NULL |
Suppress Non-PDF Paychecks
Y/N Table Edit Default Value: N |
| 5 | INCLD_ZERO_NEG_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Suppress Zero or Negative Amount Flag
Y/N Table Edit Default Value: N |
| 6 | PY_CHK_OVERFLOW | Character(1) | VARCHAR2(1) NOT NULL |
Create overflow payslip for XMLP paychecks and advices
Y/N Table Edit Default Value: N |
| 7 | PY_SS_BURS_RPT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Report Id for Bursting Self Service Paycheck PDF files
Prompt Table: PY_XRPTDEFN_VW |
| 8 | PY_SS_BURS_ADVF_ID | Character(30) | VARCHAR2(30) NOT NULL |
Report Id for Bursting Self Service Advice Form PDF files
Prompt Table: PY_XRPTDEFN_VW |
| 9 | PY_SS_PRTC_RPT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Report Id for Print Checks PDF files
Prompt Table: PY_XRPTDEFN_VW |
| 10 | PY_SS_PRTA_RPT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Report Id for Print Advice Form PDF files
Prompt Table: PY_XRPTDEFN_VW |
| 11 | PY_PSLP_FILEURLID | Character(30) | VARCHAR2(30) NOT NULL |
URL ID used to store and retrieve payslip pdfs.
Prompt Table: PY_SSP_URL_VW2 |
| 12 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 13 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |