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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | 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 |