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 |