GP_PKG_DT1_VW

(SQL View)
 Index Back

Package Date Definition View

View use dto package Date definitions.

SELECT PIN_NUM + 50000000 , EFFDT , EFF_STATUS , DATE_CRITERIA_OPTN , ENTRY_TYPE_FROM , DATE_FROM , PIN_DATE_FROM_NUM , ENTRY_TYPE_YEAR , DATE_YEAR_VAL , PIN_DATE_YEAR_NUM , ENTRY_TYPE_MONTH , DATE_MONTH_VAL , PIN_DATE_MONTH_NUM , ENTRY_TYPE_DAY , DATE_DAY_VAL , PIN_DATE_DAY_NUM , RETURN_LAST_DAY , CALCULATE_OPTN , ENTRY_TYPE_YEAR2 , CALC_YEAR_VAL , PIN_CALC_YEAR_NUM , ENTRY_TYPE_MONTH2 , CALC_MONTH_VAL , PIN_CALC_MONTH_NUM , ENTRY_TYPE_DAY2 , CALC_DAY_VAL , PIN_CALC_DAY_NUM , RETURN_LAST_DAY2 , PIN_EXTR_YEAR_NUM , PIN_EXTR_MONTH_NUM , PIN_EXTR_DAY_NUM , GP_VERSION FROM PS_GP_DATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Default Value: 999999

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 DATE_CRITERIA_OPTN Character(1) VARCHAR2(1) NOT NULL Date Criteria Option
B=Build Date
C=Provide Date

Default Value: C

5 ENTRY_TYPE_FROM Character(3) VARCHAR2(3) NOT NULL Entry Type for Date From Element

Default Value: 003

Prompt Table: GP_ENT_DATE_VW

6 DATE_FROM Date(10) DATE Date From
7 PIN_DATE_FROM_NUM Number(8,0) INTEGER NOT NULL Previous Period Date From Element
8 ENTRY_TYPE_YEAR Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Default Value: 002

Prompt Table: GP_ENT_D_YMD_VW

9 DATE_YEAR_VAL Number(4,0) SMALLINT NOT NULL Date Year Value
10 PIN_DATE_YEAR_NUM Number(8,0) INTEGER NOT NULL Element number field
11 ENTRY_TYPE_MONTH Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Default Value: 002

Prompt Table: GP_ENT_D_YMD_VW

12 DATE_MONTH_VAL Number(2,0) SMALLINT NOT NULL Date Month Value
13 PIN_DATE_MONTH_NUM Number(8,0) INTEGER NOT NULL Element number field
14 ENTRY_TYPE_DAY Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Default Value: 002

Prompt Table: GP_ENT_D_YMD_VW

15 DATE_DAY_VAL Number(2,0) SMALLINT NOT NULL Date Day Value
16 PIN_DATE_DAY_NUM Number(8,0) INTEGER NOT NULL Element number field
17 RETURN_LAST_DAY Character(1) VARCHAR2(1) NOT NULL Return Last Day of the Month

Y/N Table Edit

Default Value: N

18 CALCULATE_OPTN Character(1) VARCHAR2(1) NOT NULL Calculate Option
A=Add
N=None
S=Subtract

Default Value: N

19 ENTRY_TYPE_YEAR2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Default Value: 002

Prompt Table: GP_ENT_D_YMD_VW

20 CALC_YEAR_VAL Number(3,0) SMALLINT NOT NULL Calculated Year Value
21 PIN_CALC_YEAR_NUM Number(8,0) INTEGER NOT NULL Element number field
22 ENTRY_TYPE_MONTH2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Default Value: 002

Prompt Table: GP_ENT_D_YMD_VW

23 CALC_MONTH_VAL Number(5,0) INTEGER NOT NULL Calculated Month Value
24 PIN_CALC_MONTH_NUM Number(8,0) INTEGER NOT NULL Element number field
25 ENTRY_TYPE_DAY2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Default Value: 002

Prompt Table: GP_ENT_D_YMD_VW

26 CALC_DAY_VAL Number(7,0) INTEGER NOT NULL Calculated Day Value
27 PIN_CALC_DAY_NUM Number(8,0) INTEGER NOT NULL Element number field
28 RETURN_LAST_DAY2 Character(1) VARCHAR2(1) NOT NULL Return Last Day of the Month

Y/N Table Edit

Default Value: N

29 PIN_EXTR_YEAR_NUM Number(8,0) INTEGER NOT NULL Element number field
30 PIN_EXTR_MONTH_NUM Number(8,0) INTEGER NOT NULL Element number field
31 PIN_EXTR_DAY_NUM Number(8,0) INTEGER NOT NULL Element number field
32 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.