GPSC_ELM_ABS_TK

(SQL View)
 Index Back

Absence Take Rules Dfn

Setup/Maintain Absence Take Elements - Main Record.

SELECT PIN_NUM , EFFDT , EFF_STATUS , ABS_TYPE_OPTN , TAKE_CONFIG1 , TAKE_CONFIG2 , TAKE_CONFIG3 , TAKE_CONFIG4 , MGR_APPR_REQ_IND , MULTIPLE_INST_IND , PIN_BAL_OFFSET_NUM , ENTRY_TYPE_FROM , DATE_FROM , PIN_DATE_FROM_NUM , ENTRY_TYPE_TO , DATE_TO , PIN_DATE_TO_NUM , PIN_LINKED_TO_NUM , PIN_LINK_COND_NUM , PIN_DAY_FM_NUM , ENTRY_TYPE_ELEM , ELIG_PRD_IND , ELIG_DATE , PIN_ELIG_DATE_NUM , ENTRY_TYPE_ELEM2 , MIN_PRD_IND , PIN_MIN_PRD_NUM , MIN_PRD_VAL , ENTRY_TYPE_ELEM3 , WAIT_PRD_IND , PIN_WAIT_PRD_NUM , WAIT_PRD_VAL , PIN_WAIT_CNT_NUM , ENTRY_TYPE_ELEM4 , LINK_PRD_IND , PIN_LINK_PRD_NUM , LINK_PRD_VAL , LINK_FROM_OPTN , LINK_PRD_UNIT_OPTN , SAME_ABSENCE_IND , ENTRY_TYPE_ELEM5 , NEG_BAL_OPTN , NEG_LMT_VAL , PIN_NEG_ABS_NUM , PIN_NEG_LMT_NUM , EVT_DUP_IND , EVT_PRIORITY , PIN_FCST_NUM , GP_VERSION FROM PS_GP_ABS_TAKE WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , EFFDT , EFF_STATUS , ABS_TYPE_OPTN , TAKE_CONFIG1 , TAKE_CONFIG2 , TAKE_CONFIG3 , TAKE_CONFIG4 , MGR_APPR_REQ_IND , MULTIPLE_INST_IND , PIN_BAL_OFFSET_NUM , ENTRY_TYPE_FROM , DATE_FROM , PIN_DATE_FROM_NUM , ENTRY_TYPE_TO , DATE_TO , PIN_DATE_TO_NUM , PIN_LINKED_TO_NUM , PIN_LINK_COND_NUM , PIN_DAY_FM_NUM , ENTRY_TYPE_ELEM , ELIG_PRD_IND , ELIG_DATE , PIN_ELIG_DATE_NUM , ENTRY_TYPE_ELEM2 , MIN_PRD_IND , PIN_MIN_PRD_NUM , MIN_PRD_VAL , ENTRY_TYPE_ELEM3 , WAIT_PRD_IND , PIN_WAIT_PRD_NUM , WAIT_PRD_VAL , PIN_WAIT_CNT_NUM , ENTRY_TYPE_ELEM4 , LINK_PRD_IND , PIN_LINK_PRD_NUM , LINK_PRD_VAL , LINK_FROM_OPTN , LINK_PRD_UNIT_OPTN , SAME_ABSENCE_IND , ENTRY_TYPE_ELEM5 , NEG_BAL_OPTN , NEG_LMT_VAL , PIN_NEG_ABS_NUM , PIN_NEG_LMT_NUM , EVT_DUP_IND , EVT_PRIORITY , PIN_FCST_NUM , GP_VERSION FROM PS_GPSC_RM_ABS_TK 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 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type

Prompt Table: GP_ABS_TYPE

5 TAKE_CONFIG1 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take
6 TAKE_CONFIG2 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take
7 TAKE_CONFIG3 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take
8 TAKE_CONFIG4 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take
9 MGR_APPR_REQ_IND Character(1) VARCHAR2(1) NOT NULL Manager Approval Required

Y/N Table Edit

10 MULTIPLE_INST_IND Character(1) VARCHAR2(1) NOT NULL Multiple Instances

Y/N Table Edit

11 PIN_BAL_OFFSET_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_FRM_N_VW

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

Prompt Table: GP_ENT_DATE_VW

13 DATE_FROM Date(10) DATE Date From
14 PIN_DATE_FROM_NUM Number(8,0) INTEGER NOT NULL Previous Period Date From Element

Prompt Table: %GP_EDIT_FLD1

15 ENTRY_TYPE_TO Character(3) VARCHAR2(3) NOT NULL Entry Type for Date To Element

Prompt Table: GP_ENT_DATE_VW

16 DATE_TO Date(10) DATE Previous Period Date To
17 PIN_DATE_TO_NUM Number(8,0) INTEGER NOT NULL Previous Period To Date Element

Prompt Table: %GP_EDIT_FLD2

18 PIN_LINKED_TO_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_ABSTK_VW

19 PIN_LINK_COND_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_FRMG_VW

20 PIN_DAY_FM_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_FRM_N_VW

21 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

Prompt Table: GP_ENT_DATE_VW

22 ELIG_PRD_IND Character(1) VARCHAR2(1) NOT NULL Eligibility

Y/N Table Edit

23 ELIG_DATE Date(10) DATE Eligiblity Date
24 PIN_ELIG_DATE_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD3

25 ENTRY_TYPE_ELEM2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_ABS3_VW

26 MIN_PRD_IND Character(1) VARCHAR2(1) NOT NULL Minimum Absence

Y/N Table Edit

27 PIN_MIN_PRD_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD4

28 MIN_PRD_VAL Signed Number(8,2) DECIMAL(6,2) NOT NULL Minimum Period Value
29 ENTRY_TYPE_ELEM3 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_ABS3_VW

30 WAIT_PRD_IND Character(1) VARCHAR2(1) NOT NULL Wait Per Absence

Y/N Table Edit

31 PIN_WAIT_PRD_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD5

32 WAIT_PRD_VAL Signed Number(8,2) DECIMAL(6,2) NOT NULL Wait Period Value
33 PIN_WAIT_CNT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_FRM_N_VW

34 ENTRY_TYPE_ELEM4 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_ABS3_VW

35 LINK_PRD_IND Character(1) VARCHAR2(1) NOT NULL Link Absence

Y/N Table Edit

36 PIN_LINK_PRD_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD6

37 LINK_PRD_VAL Signed Number(8,2) DECIMAL(6,2) NOT NULL Link Period Value
38 LINK_FROM_OPTN Character(1) VARCHAR2(1) NOT NULL Starting From
E=End Date of Last Occurrence
F=Start Date of 1st Occurrence
39 LINK_PRD_UNIT_OPTN Character(1) VARCHAR2(1) NOT NULL Linked Within Absence Unit Opt
D=Days
M=Months
W=Weeks
40 SAME_ABSENCE_IND Character(1) VARCHAR2(1) NOT NULL By Original Begin Date

Y/N Table Edit

41 ENTRY_TYPE_ELEM5 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_ABS2_VW

42 NEG_BAL_OPTN Character(1) VARCHAR2(1) NOT NULL Negative Balance Option
A=Allow Negative Balance
O=Take with Other Absence
U=Take as Unpaid Time
43 NEG_LMT_VAL Signed Number(8,2) DECIMAL(6,2) NOT NULL Negative Limit Value
44 PIN_NEG_ABS_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_ABSTK_VW

45 PIN_NEG_LMT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD7

46 EVT_DUP_IND Character(1) VARCHAR2(1) NOT NULL allow overlapping instances of absence
0=No Duplicates Allowed
1=Duplicates Ok

Y/N Table Edit

47 EVT_PRIORITY Number(3,0) SMALLINT NOT NULL Event Priority
48 PIN_FCST_NUM Number(8,0) INTEGER NOT NULL This field is used on the GP_ABS_TAKE definition to identify the forecast element to be resolved during forecasting for the event associated with that take.

Prompt Table: GP_PIN_FM1_VW

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