OI_SRC_VW

(SQL View)
 Index Back

Source

Primary record for Source

SELECT SRC.SETID , SRC.SOURCE , SRC.EFFDT , ED.EFF_END_DT , SRC.EFF_STATUS , SRC.DESCR , XLI1.DESCR JRNL_BALANCE_OPTN , XLI2.DESCR JRNL_EDIT_ERR_OPTN , XLI3.DESCR JRNL_AMT_ERR_OPTN , XLI4.DESCR JRNL_DT_ERR_OPTN , XLI5.DESCR JRNL_DT_ERR_OPTN2 , XLI6.DESCR CONTROL_TOTAL_OPTN , XLI7.DESCR CURRENCY_BAL_OPTN , XLI8.DESCR EXCHANGE_RATE_OPTN , XLI9.DESCR BASE_CUR_ADJ_OPTN , XLI10.DESCR JRNL_FOREIGN_OPTN , SRC.POST_ZERO_SW , XLI12.DESCR JRNL_APPRVL_OPTN , XLI13.DESCR BD_JRNL_APPR_OPTN , BPD1.BUSPROCNAME , BPD1.DESCR60 , APH_ED1.APPR_RULE_SET , BPD2.BUSPROCNAME BUSPROCNAME_BD , BPD2.DESCR60 DESCR60_1 , APH_ED2.APPR_RULE_SET APPR_RULE_SET_BD , XLI20.DESCR PHYSICAL_NATURE , XLI21.DESCR DOC_TYPE_OPTN , DY.DOC_TYPE , DY.DESCR DOC_TYP_DESCR FROM PS_SOURCE_TBL SRC INNER JOIN %Table(OI_SRC_EFF_VW) ED ON SRC.SETID = ED.SETID AND SRC.SOURCE=ED.SOURCE AND SRC.EFFDT =ED.EFF_ST_DT LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = SRC.JRNL_BALANCE_OPTN AND XLI1.CODESETGROUPNAME ='JRNL_BALANCE_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI2 ON XLI2.CODESETNAME = SRC.JRNL_EDIT_ERR_OPTN AND XLI2.CODESETGROUPNAME ='JRNL_EDIT_ERR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI3 ON XLI3.CODESETNAME = SRC.JRNL_AMT_ERR_OPTN AND XLI3.CODESETGROUPNAME ='JRNL_AMT_ERR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI4 ON XLI4.CODESETNAME = SRC.JRNL_DT_ERR_OPTN AND XLI4.CODESETGROUPNAME ='JRNL_DT_ERR_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI5 ON XLI5.CODESETNAME = SRC.JRNL_DT_ERR_OPTN2 AND XLI5.CODESETGROUPNAME ='JRNL_DT_ERR_OPTN2' LEFT OUTER JOIN PS_OI_COMMON_VW XLI6 ON XLI6.CODESETNAME = SRC.CONTROL_TOTAL_OPTN AND XLI6.CODESETGROUPNAME ='CONTROL_TOTAL_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI7 ON XLI7.CODESETNAME = SRC.CURRENCY_BAL_OPTN AND XLI7.CODESETGROUPNAME ='CURRENCY_BAL_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI8 ON XLI8.CODESETNAME = SRC.EXCHANGE_RATE_OPTN AND XLI8.CODESETGROUPNAME ='EXCHANGE_RATE_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI9 ON XLI9.CODESETNAME = SRC.BASE_CUR_ADJ_OPTN AND XLI9.CODESETGROUPNAME ='BASE_CUR_ADJ_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI10 ON XLI10.CODESETNAME = SRC.JRNL_FOREIGN_OPTN AND XLI10.CODESETGROUPNAME ='JRNL_FOREIGN_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI12 ON XLI12.CODESETNAME = SRC.JRNL_APPRVL_OPTN AND XLI12.CODESETGROUPNAME ='JRNL_APPRVL_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI13 ON XLI13.CODESETNAME = SRC.BD_JRNL_APPR_OPTN AND XLI13.CODESETGROUPNAME ='BD_JRNL_APPR_OPTN' LEFT OUTER JOIN PSBUSPROCDEFN BPD1 ON SRC.BUSPROCNAME=BPD1.BUSPROCNAME LEFT OUTER JOIN ( SELECT ARH1.APPR_RULE_SET , ARH1.EFFDT FROM PS_APPR_RULE_HDR ARH1 WHERE EFFDT= ( SELECT MAX(EFFDT) FROM PS_APPR_RULE_HDR ED1 WHERE ARH1.APPR_RULE_SET=ED1.APPR_RULE_SET ) ) APH_ED1 ON SRC.APPR_RULE_SET=APH_ED1.APPR_RULE_SET AND APH_ED1.EFFDT <= SRC.EFFDT LEFT OUTER JOIN PSBUSPROCDEFN BPD2 ON SRC.BUSPROCNAME_BD=BPD2.BUSPROCNAME LEFT OUTER JOIN ( SELECT ARH2.APPR_RULE_SET , ARH2.EFFDT FROM PS_APPR_RULE_HDR ARH2 WHERE EFFDT= ( SELECT MAX(EFFDT) FROM PS_APPR_RULE_HDR ED2 WHERE ARH2.APPR_RULE_SET=ED2.APPR_RULE_SET ) ) APH_ED2 ON SRC.APPR_RULE_SET_BD=APH_ED2.APPR_RULE_SET AND APH_ED2.EFFDT <= SRC.EFFDT LEFT OUTER JOIN PS_OI_COMMON_VW XLI20 ON XLI20.CODESETNAME = SRC.PHYSICAL_NATURE AND XLI20.CODESETGROUPNAME ='PHYSICAL_NATURE' LEFT OUTER JOIN PS_OI_COMMON_VW XLI21 ON XLI21.CODESETNAME = SRC.DOC_TYPE_OPTN AND XLI21.CODESETGROUPNAME ='DOC_TYPE_OPTN' LEFT OUTER JOIN PS_DOC_TYPE_TBL DY ON SRC.SETID =DY.SETID AND SRC.DOC_TYPE=DY.DOC_TYPE UNION SELECT SETID , ' ' , %DateIn('1900-01-01') , %DateIn('9999-12-31') , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_SETID_TBL UNION SELECT ' ' , ' ' , %DateIn('1900-01-01') , %DateIn('9999-12-31') , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_INSTALLATION

# 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
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 JL_BAL_OPTN_DESCR Character(30) VARCHAR2(30) NOT NULL Journal Balance Option Descr
8 JL_ED_ER_OPTN_DESR Character(30) VARCHAR2(30) NOT NULL Journal Edit Errors Option
9 JL_AM_ER_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Journal Amount Errors Option
10 JL_DT_ER_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL JRNL Dt Less Than Open From Dt
11 JLDT_ER_OPTN2_DESC Character(30) VARCHAR2(30) NOT NULL JRNL Dt Less Than Open To Dt
12 CTL_TOT_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Control Total Option
13 CURR_BAL_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Currency Balancing Option
14 EX_RT_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Translate Ledger Exchange Rate
15 BCUR_ADJ_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Base currency Adjusment option
16 JL_FOR_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Foreign Currencies per Journal
17 POST_ZERO_SW Character(1) VARCHAR2(1) NOT NULL Post Zero Amount Journal Lines
18 JL_APPRL_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Journal Approval Option
19 BD_JLAPR_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Unit of measure description
20 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
21 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
22 APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set
23 BUSPROCNAME_BD Character(30) VARCHAR2(30) NOT NULL Business Process Name - Budget
24 DESCR60_2 Character(60) VARCHAR2(60) NOT NULL Description
25 APPR_RULE_SET_BD Character(30) VARCHAR2(30) NOT NULL Approval Rule Set - Budgets
26 PHY_NATURE_DESC Character(30) VARCHAR2(30) NOT NULL Physical Nature Description
27 DOC_TYPE_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Document Type description
28 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
29 DOC_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Document Type Description