ST_PUR_PRCS_GRP

(SQL Table)
Index Back

Purchase Period Group

This table defines the additional groups to be included/excluded from the purchase process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PURCHASE_ID Character(10) VARCHAR2(10) NOT NULL Purchase ID
2 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group

Prompt Table: ST_PROCESS_GRP

3 ESPP_GATHER_RUN Character(1) VARCHAR2(1) NOT NULL Gather Contributions

Default Value: N

4 ESPP_GATHER_DTTM DateTime(26) TIMESTAMP Gather Contributions Last Run
5 ESPP_CURR_RUN Character(1) VARCHAR2(1) NOT NULL Convert Currencies

Default Value: N

6 ESPP_CURR_DTTM DateTime(26) TIMESTAMP Convert Currencies Last Run
7 ESPP_PURCHASE_RUN Character(1) VARCHAR2(1) NOT NULL Purchase Stock

Default Value: N

8 ESPP_PURCHASE_DTTM DateTime(26) TIMESTAMP Purchase Stock Last Run
9 ESPP_CONFIRM_RUN Character(1) VARCHAR2(1) NOT NULL Confirm Purchase

Default Value: N

10 ESPP_CONFIRM_DTTM DateTime(26) TIMESTAMP Confirm Purchase Last Run
11 ESPP_UNCONFRM_RUN Character(1) VARCHAR2(1) NOT NULL UnConfirm Purchase

Default Value: N

12 ESPP_UNCONFRM_DTTM DateTime(26) TIMESTAMP UnConfirm Purchase Last Run
13 CONFIRMED Character(1) VARCHAR2(1) NOT NULL Confirmed

Default Value: N