SYSPIN_SRCD=Database Field
S=System-Computed
Default Value: D
RECNAMEPrompt Table: RECDEFNLANG_VW
PIN_NUMLANGUAGE_CDGP_SYSPIN_VL(SQL View) |
Index Back |
|---|---|
RelLang-Sys PIN Details ViewRelated Language Record for GP_SYSPIN_VW. |
| SELECT A.SYSPIN_SRC , A.RECNAME ,B.PIN_NUM ,L.LANGUAGE_CD , L.PIN_NM FROM PS_GP_SYSTEM_PIN A , PS_GP_PIN B ,PS_GP_PIN_LANG L WHERE A.PIN_NUM = B.PIN_NUM AND B.PIN_NUM=L.PIN_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SYSPIN_SRC |
Character(1) | VARCHAR2(1) NOT NULL |
System Element Source
D=Database Field S=System-Computed Default Value: D |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFNLANG_VW |
| 3 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |