GP_NRP_GLPIN_VW

(SQL View)
 Index Back

GL Distribution Overrides View

GL Distribution Overrides PIN level entries - Packaging View

SELECT EMPLID ,EMPL_RCD ,EFFDT ,PIN_CHART1_VAL ,PIN_CHART2_VAL ,PIN_CHART3_VAL ,PIN_CHART4_VAL ,PIN_CHART5_VAL ,PIN_CHART6_VAL ,PIN_CHART7_VAL ,PIN_CHART8_VAL ,PIN_CHART9_VAL ,PIN_CHART10_VAL ,PIN_CHART11_VAL ,PIN_CHART12_VAL ,PIN_CHART13_VAL ,PIN_CHART14_VAL ,PIN_CHART15_VAL ,PIN_CHART16_VAL ,PIN_CHART17_VAL ,PIN_CHART18_VAL ,PIN_CHART19_VAL ,PIN_CHART20_VAL ,PIN_CHART21_VAL ,PIN_NUM + 50000000 ,ENTRY_TYPE_ID ,PCT_TO_ALLOCATE ,ACCT_CD FROM PS_GP_GL_DIST_PIN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE Effective Date
4 PIN_CHART1_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD1

5 PIN_CHART2_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD2

6 PIN_CHART3_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value`

Prompt Table: %GP_EDIT_FLD3

7 PIN_CHART4_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD4

8 PIN_CHART5_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD5

9 PIN_CHART6_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD6

10 PIN_CHART7_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD7

11 PIN_CHART8_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD8

12 PIN_CHART9_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD9

13 PIN_CHART10_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD10

14 PIN_CHART11_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD11

15 PIN_CHART12_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD12

16 PIN_CHART13_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %GP_EDIT_FLD13

17 PIN_CHART14_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %EDITTABLE14

18 PIN_CHART15_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %EDITTABLE15

19 PIN_CHART16_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %EDITTABLE16

20 PIN_CHART17_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %EDIT_BU_PC

21 PIN_CHART18_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %EDIT_ACTIVITY

22 PIN_CHART19_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %EDIT_RESOURCE

23 PIN_CHART20_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %EDIT_RES_CAT

24 PIN_CHART21_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value

Prompt Table: %EDIT_RES_SUB

25 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
26 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID
27 PCT_TO_ALLOCATE Number(10,6) DECIMAL(9,6) NOT NULL Percent to Allocate

Default Value: 100

28 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code