BUDGET_COMP2_VW (SQL View)	Index Back
Budget Compar. Components Budget Compar. Components

BUDGET_COMP2_VW

(SQL View)

Budget Compar. Components

SELECT A.GB_GROUP_ID ,A.BUDGET_START_DT ,A.BUDGET_ID ,A.EFFDT ,A.EFFSEQ ,B.ACTION ,B.ACTION_REASON ,A.COMP_RATECD ,A.CHANGE_AMT ,A.AMOUNT_PCT ,A.CHANGE_PCT ,A.CHANGE_PTS ,A.POINT_PCT ,A.COMPRATE ,A.CURRENCY_CD ,A.FREQUENCY_ID FROM PS_GRP_INC_CMP_REQ A , PS_GRP_INCR_BUDGET B WHERE A.GB_GROUP_ID =B.GB_GROUP_ID AND A.BUDGET_START_DT =B.BUDGET_START_DT AND A.BUDGET_ID =B.BUDGET_ID AND A.EFFDT =B.EFFDT AND A.EFFSEQ =B.EFFSEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

2 BUDGET_START_DT Date(10) DATE Budget Period Start Date

3 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID

4 EFFDT Date(10) DATE Effective Date

5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

6 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTION_TBL

7 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

8 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

9 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount

10 AMOUNT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent Amount

11 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent

12 CHANGE_PTS Signed Number(6,0) DECIMAL(5) NOT NULL Change Points

13 POINT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent of Points

14 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate

15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

16 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
2	BUDGET_START_DT	Date(10)	DATE	Budget Period Start Date
3	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
4	EFFDT	Date(10)	DATE	Effective Date
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
7	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
8	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
9	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
10	AMOUNT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percent Amount
11	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
12	CHANGE_PTS	Signed Number(6,0)	DECIMAL(5) NOT NULL	Change Points
13	POINT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percent of Points
14	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.