SETIDANALYSIS_TYPEEFF_ST_DTA=Active
I=Inactive
OI_ANATY_VW(SQL View) |
Index Back |
|---|---|
Analysis TypePrimary record for Analysis Type |
| SELECT PAT.SETID , PAT.ANALYSIS_TYPE , PAT.EFFDT , ED.EFF_END_DT , PAT.EFF_STATUS , PAT.DESCR , XLI1.DESCR KK_AMT_TYP_DESC , PAT.KK_SOURCE_TRAN , KST.DESCR KK_SOURCE_TRAN_DESCR FROM PS_PROJ_ANTYPE_TBL PAT INNER JOIN %Table(OI_ANATY_EFF_VW) ED ON PAT.SETID = ED.SETID AND PAT.ANALYSIS_TYPE=ED.ANALYSIS_TYPE AND PAT.EFFDT =ED.EFF_ST_DT LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = PAT.KK_AMOUNT_TYPE AND XLI1.CODESETGROUPNAME='KK_AMOUNT_TYPE' LEFT OUTER JOIN PS_KK_SOURCE_TRAN KST ON PAT.KK_SOURCE_TRAN = KST.KK_SOURCE_TRAN UNION SELECT DISTINCT SETID , ' ' , %DateIn('1900-01-01') , %DateIn('9999-12-31') , 'A' , 'Not Available' , '-' , '-' , '-' FROM PS_SETID_TBL UNION SELECT ' ' , ' ' , %DateIn('1900-01-01') , %DateIn('9999-12-31') , 'A' , 'Not Available' , '-' , '-' , '-' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ANALYSIS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 3 | EFF_ST_DT |
Date(10) | DATE | Effective Start Date |
| 4 | EFF_END_DT | Date(10) | DATE | Effective End Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | KK_AMT_TYP_DESC | Character(30) | VARCHAR2(30) NOT NULL | Commitment Control Amount Type description |
| 8 | KK_SOURCE_TRAN | Character(10) | VARCHAR2(10) NOT NULL | Source Transaction Type |
| 9 | KK_SRC_TRAN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Source Transaction Type |