PYCYCL_WRK_OPT

(SQL Table)
Index Back

PayCycle Workflowing options

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
2 TRIAL_REG_FLG Character(1) VARCHAR2(1) NOT NULL User Approval
C=Certifier Approval
N=None
U=User Approval

Default Value: N

3 AUTO_INC_FLG Character(1) VARCHAR2(1) NOT NULL Automatic Increment Dates

Default Value: N

4 PROCESS_CYCLE Character(1) VARCHAR2(1) NOT NULL Allow Automatic Processing

Default Value: N

5 STEP_TBL_NAME Character(15) VARCHAR2(15) NOT NULL Step Group Name

Default Value: Model

Prompt Table: PYCYCL_STEP_HDR

6 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By

Prompt Table: GFAP_CERTAP_VW

7 OPRID_FROM Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: GFAP_CERTAP_VW

8 PYMNT_MESSAGE Character(70) VARCHAR2(70) NOT NULL Payment Message
9 WRKFLW_CERTIFY Character(1) VARCHAR2(1) NOT NULL Workflow Certification

Y/N Table Edit

Default Value: N

10 RULE_SETID Character(5) VARCHAR2(5) NOT NULL Rule Setid

Prompt Table: SP_SETID_NONVW

11 BANK_RPL_RULE_ID Character(10) VARCHAR2(10) NOT NULL Rule Name

Prompt Table: BANK_RULE_VW

12 SUPPRESS_ZERO_CHK Character(1) VARCHAR2(1) NOT NULL Suppress Zero Amount Check

Y/N Table Edit

Default Value: N

13 REVIEW_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

Prompt Table: OPRID_VW2

14 OFAC_ENABLE Character(1) VARCHAR2(1) NOT NULL Financial Sanctions list edit

Y/N Table Edit

Default Value: N

15 EMAIL_ADVICE Character(1) VARCHAR2(1) NOT NULL Email Payment Advice
N=No
Y=Yes

Y/N Table Edit

Default Value: N

16 PRINT_EMAIL_ACH Character(1) VARCHAR2(1) NOT NULL Print Email ACH/EFT Advice

Y/N Table Edit

Default Value: N

17 PRINTER_TYPE Character(3) VARCHAR2(3) NOT NULL This field is added to print xmlp check in different types, such as PDF, PCL and PS.
PCL=PCL
PDF=PDF
PS=PS

Default Value: PDF