GPSC_ELM_DATE (SQL View)	Index Back
Date Definition. Date rule definitions - Main record.

GPSC_ELM_DATE

(SQL View)

Date Definition.

Date rule definitions - Main record.

SELECT PIN_NUM , 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 , PIN_DATE_DAY_NUM , DATE_DAY_VAL , 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 WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , 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 , PIN_DATE_DAY_NUM , DATE_DAY_VAL , 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_GPSC_RM_DATE WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

2 EFFDT Date(10) DATE NOT NULL Effective Date

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

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

5 ENTRY_TYPE_FROM Character(3) VARCHAR2(3) NOT NULL Entry Type for Date From Element
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
Prompt Table: %GP_EDIT_FLD1

8 ENTRY_TYPE_YEAR Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
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
Prompt Table: %GP_EDIT_FLD2

11 ENTRY_TYPE_MONTH Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
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
Prompt Table: %GP_EDIT_FLD3

14 ENTRY_TYPE_DAY Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
Prompt Table: GP_ENT_D_YMD_VW

15 PIN_DATE_DAY_NUM Number(8,0) INTEGER NOT NULL Element number field
Prompt Table: %GP_EDIT_FLD4

16 DATE_DAY_VAL Number(2,0) SMALLINT NOT NULL Date Day Value

17 RETURN_LAST_DAY Character(1) VARCHAR2(1) NOT NULL Return Last Day of the Month
Y/N Table Edit

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

19 ENTRY_TYPE_YEAR2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
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
Prompt Table: %GP_EDIT_FLD5

22 ENTRY_TYPE_MONTH2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
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
Prompt Table: %GP_EDIT_FLD6

25 ENTRY_TYPE_DAY2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
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
Prompt Table: %GP_EDIT_FLD7

28 RETURN_LAST_DAY2 Character(1) VARCHAR2(1) NOT NULL Return Last Day of the Month
Y/N Table Edit

29 PIN_EXTR_YEAR_NUM Number(8,0) INTEGER NOT NULL Element number field
Prompt Table: GP_PIN_VR2EL_VW

30 PIN_EXTR_MONTH_NUM Number(8,0) INTEGER NOT NULL Element number field
Prompt Table: GP_PIN_VR2EL_VW

31 PIN_EXTR_DAY_NUM Number(8,0) INTEGER NOT NULL Element number field
Prompt Table: GP_PIN_VR2EL_VW

32 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
4	DATE_CRITERIA_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Date Criteria Option B=Build Date C=Provide Date
5	ENTRY_TYPE_FROM	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date From Element 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 Prompt Table: %GP_EDIT_FLD1
8	ENTRY_TYPE_YEAR	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field 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 Prompt Table: %GP_EDIT_FLD2
11	ENTRY_TYPE_MONTH	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field 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 Prompt Table: %GP_EDIT_FLD3
14	ENTRY_TYPE_DAY	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field Prompt Table: GP_ENT_D_YMD_VW
15	PIN_DATE_DAY_NUM	Number(8,0)	INTEGER NOT NULL	Element number field Prompt Table: %GP_EDIT_FLD4
16	DATE_DAY_VAL	Number(2,0)	SMALLINT NOT NULL	Date Day Value
17	RETURN_LAST_DAY	Character(1)	VARCHAR2(1) NOT NULL	Return Last Day of the Month Y/N Table Edit
18	CALCULATE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Calculate Option A=Add N=None S=Subtract
19	ENTRY_TYPE_YEAR2	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field 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 Prompt Table: %GP_EDIT_FLD5
22	ENTRY_TYPE_MONTH2	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field 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 Prompt Table: %GP_EDIT_FLD6
25	ENTRY_TYPE_DAY2	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field 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 Prompt Table: %GP_EDIT_FLD7
28	RETURN_LAST_DAY2	Character(1)	VARCHAR2(1) NOT NULL	Return Last Day of the Month Y/N Table Edit
29	PIN_EXTR_YEAR_NUM	Number(8,0)	INTEGER NOT NULL	Element number field Prompt Table: GP_PIN_VR2EL_VW
30	PIN_EXTR_MONTH_NUM	Number(8,0)	INTEGER NOT NULL	Element number field Prompt Table: GP_PIN_VR2EL_VW
31	PIN_EXTR_DAY_NUM	Number(8,0)	INTEGER NOT NULL	Element number field Prompt Table: GP_PIN_VR2EL_VW
32	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.