OI_SRC_EFF_VW(SQL View) |
Index Back |
|---|---|
SourceSource with Effective Start Date & End Date |
| SELECT SETID , SOURCE , EFFDT AS EFF_ST_DT , CASE WHEN LEAD(CONCAT(SETID ,SOURCE) ,1 ,NULL) OVER ( ORDER BY SETID ,SOURCE ,EFFDT) <> CONCAT (SETID ,SOURCE) THEN TO_DATE('9999-12-31' , 'YYYY-MM-DD') ELSE CASE WHEN LEAD(EFFDT ,1 ,NULL) OVER ( ORDER BY SETID ,SOURCE ,EFFDT) = EFFDT THEN EFFDT ELSE LEAD(EFFDT-1 ,1 ,TO_DATE('9999-12-31' , 'YYYY-MM-DD')) OVER ( ORDER BY SETID ,SOURCE ,EFFDT) END END AS EFF_END_DT FROM PS_SOURCE_TBL ORDER BY 1 , 2 , 3 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SOURCE | Character(3) | VARCHAR2(3) NOT NULL | Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual. |
| 3 | EFF_ST_DT | Date(10) | DATE | Effective Start Date |
| 4 | EFF_END_DT | Date(10) | DATE | Effective End Date |