COMPANYPAYGROUPPAY_END_DTOFF_CYCLEY/N Table Edit
Default Value: N
PAGE_NUMC=Check Only
N=Not Applicable
P=Paysheet Only
F=FLSA Paysheet
K=Batch Final Check
L=Online Final Check
O=On-line Paysheet
P=Paysheet Load
S=Regular Paysheet
SSF_PAY_PAGE_VW(SQL View) |
Index Back |
|---|---|
Pay Page ViewThis view is used to access payroll page information. |
| SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.SINGLE_CHECK_USE ,A.PAY_SHEET_SRC FROM PS_PAY_PAGE A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 3 | PAY_END_DT |
Date(10) | DATE NOT NULL | Pay Period End Date |
| 4 | OFF_CYCLE |
Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit Default Value: N |
| 5 | PAGE_NUM |
Number(4,0) | SMALLINT NOT NULL | Page # |
| 6 | SINGLE_CHECK_USE | Character(1) | VARCHAR2(1) NOT NULL |
How is Single Check Used
C=Check Only N=Not Applicable P=Paysheet Only |
| 7 | PAY_SHEET_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Source of Paysheet
F=FLSA Paysheet K=Batch Final Check L=Online Final Check O=On-line Paysheet P=Paysheet Load S=Regular Paysheet |