GP_FFMT_LANG_VW(SQL View) |
Index Back |
---|---|
RelLang for FLD FMT in XLATtblGlobal Payroll Field Format (Xlat table) Related Language Record |
SELECT %Substring(FIELDVALUE, 1, 1) ,LANGUAGE_CD ,EFFDT ,XLATSHORTNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'FLD_FMT' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FLD_FMT | Character(1) | VARCHAR2(1) NOT NULL |
Field format for Global Payroll elements
1=Character 2=Date 3=Monetary 4=Decimal 5=Element Pointer 6=Not Applicable |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | EFFDT | Date(10) | DATE | Effective Date |
4 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |