EMPLIDEMPL_RCDCOUNTRYRUN_TYPEPrompt Table: GP_RUN_TYPE
LANGUAGE_CDGP_NPDCNFVW_LNG(SQL View) |
Index Back |
|---|---|
RelLang GP Run Type ViewGlobal Payroll Self Service Related language view of GP_SS_NPD_CNFVW. |
| SELECT C.EMPLID , C.EMPL_RCD ,R.COUNTRY ,R.RUN_TYPE ,R2.LANGUAGE_CD ,R2.DESCR FROM PS_GP_RUN_TYPE R1 , PS_GP_RUN_TYP_LANG R2 , PS_GP_SSEEPGCTRYVW C , PS_GP_SS_NPD_CONF R WHERE R1.RUN_TYPE = R.RUN_TYPE AND R2.RUN_TYPE = R1.RUN_TYPE AND C.COUNTRY = R.COUNTRY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 4 | RUN_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Run Type Name
Prompt Table: GP_RUN_TYPE |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |