PE_BU_CAL_VW

(SQL View)

SELECT DISTINCT Z2.OPRID , Z2.RUN_CNTL_ID , Z1.BUSINESS_UNIT_GL , Z1.BUSINESS_UNIT_GL , SET1.SETID , CAL1.CALENDAR_ID , CAL1.BEGIN_DT , CAL1.END_DT , Z1.APPL_JRNL_ID_PEACR , CAL1.ACCOUNTING_PERIOD , CAL1.FISCAL_YEAR , 'R' FROM PS_CAL_DETP_TBL CAL1 , PS_BU_LED_GRP_TBL GRP1 , PS_LED_GRP_LED_TBL LED1 , PS_SET_CNTRL_REC SET1 , PS_BUS_UNIT_TBL_EX Z1 , PS_PE_ACCRL_RQST Z2 WHERE CAL1.SETID = SET1.SETID AND CAL1.CALENDAR_ID = GRP1.CALENDAR_ID AND GRP1.BUSINESS_UNIT = Z1.BUSINESS_UNIT_GL AND GRP1.BUSINESS_UNIT = SET1.SETCNTRLVALUE AND SET1.RECNAME = 'CAL_DETP_TBL' AND GRP1.DEFAULT_LEDGER_GRP = 'Y' AND GRP1.LEDGER_GROUP = LED1.LEDGER_GROUP AND LED1.PRIMARY_LEDGER = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

6 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

7 BEGIN_DT Date(10) DATE Begin Date

8 END_DT Date(10) DATE End Date

9 APPL_JRNL_ID_PEACR Character(10) VARCHAR2(10) NOT NULL Period End Accruals

10 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

11 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

12 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
6	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
7	BEGIN_DT	Date(10)	DATE	Begin Date
8	END_DT	Date(10)	DATE	End Date
9	APPL_JRNL_ID_PEACR	Character(10)	VARCHAR2(10) NOT NULL	Period End Accruals
10	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
11	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
12	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization