SCC_BRINCD_NLDSCC_BRINCD_VW(SQL View) |
Index Back |
|---|---|
View on Dutch Brincode TableView on Dutch Brincode Table showing the latests effective dated Brincode and Brincode description |
| SELECT A.SCC_BRINCD_NLD , A.DESCR100 FROM PS_SCC_BRINCD_NLD A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_SCC_BRINCD_NLD A_ED WHERE A.SCC_BRINCD_NLD = A_ED.SCC_BRINCD_NLD AND A_ED.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_BRINCD_NLD |
Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |