EMPLIDPrompt Table: PERS_SRCH_GBL
EFFDTDefault Value: %date
Default Value: FRA
Prompt Table: GPCH_RC_PAYROLL
1=RTF
2=PDF
3=HTML
4=Excel
5=Powerpoint
Default Value: 1
1=103
2=041
GPCH_RC_UNEMP(SQL Table) |
Index Back |
|---|---|
GPCH_RC_UNEMPUnemployment report |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
Default Value: FRA |
| 4 | GPCH_PAY_BALANCE | Character(20) | VARCHAR2(20) NOT NULL |
GPCH_PAY_BALANCE
Prompt Table: GPCH_RC_PAYROLL |
| 5 | GPCH_REP_FORMAT | Character(2) | VARCHAR2(2) NOT NULL |
Report format
1=RTF 2=PDF 3=HTML 4=Excel 5=Powerpoint Default Value: 1 |
| 6 | GPCH_REP_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
GPCH_REP_TYPE
1=103 2=041 |
| 7 | GPCH_GEN_REPORT | Character(5) | VARCHAR2(5) NOT NULL | GPCH_GEN_REPORT |
| 8 | GPCH_TAX_STMT | Character(5) | VARCHAR2(5) NOT NULL | GPCH_TAX_STMT |