ACCOUNTALTACCTLANGUAGE_CDAP_ALTACCTVW_LG(SQL View) |
Index Back |
|---|
| SELECT X.ACCOUNT , X.ALTACCT , MAX(B.LANGUAGE_CD) , MAX(B.DESCR) FROM PS_ALTACCT_XREF X , PS_ALTACCT_TBL A , PS_ALTACCT_LANG B WHERE A.SETID = X.ALTACCT_SETID AND A.ALTACCT = X.ALTACCT AND A.EFFDT = ( SELECT MAX(T.EFFDT) FROM PS_ALTACCT_TBL T WHERE T.SETID = A.SETID AND T.ALTACCT = A.ALTACCT AND T.EFFDT <= %CurrentDateIn AND T.EFF_STATUS = 'A') AND A.SETID = B.SETID AND A.ALTACCT = B.ALTACCT AND A.EFFDT = B.EFFDT GROUP BY X.ACCOUNT, X.ALTACCT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 2 | ALTACCT |
Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |