OI_LEDG_VW

(SQL View)
 Index Back

Ledger

Primary record for Ledger ChartField

SELECT LD.SETID , LD.LEDGER , LD.EFFDT , ED.EFF_END_DT , LD.DESCR , LD.LEDGER_TEMPLATE , LD.LEDGER_TYPE , LD.BUDGET_TYPE , LD.SCENARIO , LD.DETAIL_TMPLT FROM PS_LED_DEFN_TBL LD INNER JOIN %Table(OI_LEDG_EFF_VW) ED ON LD.SETID = ED.SETID AND LD.LEDGER=ED.LEDGER AND LD.EFFDT =ED.EFF_ST_DT UNION SELECT DISTINCT SETID , ' ' , %DateIn('1900-01-01') , %DateIn('9999-12-31') , 'Not Available' , 'NA' , '-' , '-' , '-' , '-' FROM PS_SETID_TBL UNION SELECT ' ' , ' ' , %DateIn('1900-01-01') , %DateIn('9999-12-31') , 'Not Available' , 'NA' , '-' , '-' , '-' , '-' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
3 EFF_ST_DT Date(10) DATE Effective Start Date
4 EFF_END_DT Date(10) DATE Effective End Date
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 LEDGER_TEMPLATE Character(10) VARCHAR2(10) NOT NULL Ledger Template
7 LEDGER_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Type
D=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
8 BUDGET_TYPE Character(2) VARCHAR2(2) NOT NULL Budget Type
AL=Allotment Budget
AP=Appropriation Budget
IN=Initial Budget
IS=Installment Budget
OR=Organizational Budget
OT=Other
PR=Project/Grant Budget
RE=Revenue Estimate
SU=Supplemental Budget
9 SCENARIO Character(10) VARCHAR2(10) NOT NULL A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
10 DETAIL_TMPLT Character(10) VARCHAR2(10) NOT NULL Detail Template