RECNAMEPrompt Table: GP_MAP_RECNM_VW
E=Effective Date
N=Not Effective Dated
S=Begin - End Date
Prompt Table: GP_PIN_TYPE
Prompt Table: PSRECDEFN
GP_PKG_SUPP1_VW(SQL View) |
Index Back |
|---|---|
Packaging Support ViewGlobal Payroll Package Support View Record. |
| SELECT A.RECNAME , A.EFFDT_TYPE , B.PIN_TYPE , A.RECNAME_EXPORT , 'N' FROM PS_GP_PIN_FLD_MAP1 A , PS_GP_PIN_FLD_MAP4 B WHERE A.RECNAME = B.RECNAME AND A.FIELDNAME_KEY1 = B.FIELDNAME_KEY1 AND A.RECORD_TYPE_OPT = 'R' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: GP_MAP_RECNM_VW |
| 2 | EFFDT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
"Effective" Date Type. Indicates what type of date fields manages the effective date span on a given table. Used with managing triggers. Has codeset (XLAT values).
E=Effective Date N=Not Effective Dated S=Begin - End Date |
| 3 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Element Type
Prompt Table: GP_PIN_TYPE |
| 4 | RECNAME_EXPORT | Character(15) | VARCHAR2(15) NOT NULL |
Export Record (Table) Name
Prompt Table: PSRECDEFN |
| 5 | GP_PKG_UPG_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Field used for element packaging |