GPDE_RC_SI10(SQL Table) |
Index Back |
|---|---|
Run Control SI ContributionsRun Control SI Contributions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | GPDE_AL_CPAY_ENDDT | Date(10) | DATE | Current Pay End Date |
| 6 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
| 7 | GPDE_DV_RCVER_ID | Character(8) | VARCHAR2(8) NOT NULL |
Provider ID
Prompt Table: GPDE_DV_RCVR_VW |
| 8 | GPDE_RC_YR_CLOSE | Character(1) | VARCHAR2(1) NOT NULL |
Tax Year Close
Y/N Table Edit Default Value: N |
| 9 | GPDE_RC_RESET1 | Character(1) | VARCHAR2(1) NOT NULL |
Use for reporting
Y/N Table Edit Default Value: N |
| 10 | GPDE_RC_PRN_DUE25 | Character(1) | VARCHAR2(1) NOT NULL |
Indicator on the SI-Contributionlist, that the due-date is 25th of the month
Y/N Table Edit |
| 11 | GPDE_AL_OPRNAME | Character(11) | VARCHAR2(11) NOT NULL |
Executing Clerk
Prompt Table: PERS_SRCH_GBL |
| 12 | GPDE_AL_GENDER | Character(1) | VARCHAR2(1) NOT NULL |
gender of an EE
M=Mr W=Mrs |
| 13 | GPDE_AL_CONTACT_NM | Character(50) | VARCHAR2(50) NOT NULL | executing clerk |
| 14 | GPDE_AL_PHONE | Character(24) | VARCHAR2(24) NOT NULL |
phone number of an employee
Prompt Table: GPDE_AL_PH_SRCH |
| 15 | GPDE_AL_FAX | Character(24) | VARCHAR2(24) NOT NULL |
Fax number of an employee
Prompt Table: GPDE_AL_PH_SRCH |
| 16 | GPDE_AL_EMAIL | Character(70) | VARCHAR2(70) NOT NULL |
email address of an employee
Prompt Table: GPDE_AL_EM_SRCH |