PERSON_IDLANGUAGE_CDSPB_PERSSES_LVW(SQL View) |
Index Back |
|---|---|
PTSF Person language viewPTSF Person language view |
| SELECT A.PERSON_ID ,X1.LANGUAGE_CD ,X1.XLATLONGNAME AS DESCR ,X2.XLATLONGNAME AS DESCR1 FROM PS_SPB_PERSON_TBL A , PSXLATITEMLANG X1 , PSXLATITEMLANG X2 WHERE X1.FIELDNAME = 'USER_ACC_STATUS' AND X1.FIELDVALUE = A.USER_ACC_STATUS AND %EffdtCheck(PSXLATITEMLANG X3, X1, %CurrentDateIn) AND X2.FIELDNAME = 'SP_ELIGIBLE_STATUS' AND X2.FIELDVALUE = A.SP_ELIGIBLE_STATUS AND %EffdtCheck(PSXLATITEMLANG X4, X2, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |