PYCYCL_STAT (SQL Table)	Index Back
Payment Selection Cycle Status

PYCYCL_STAT

(SQL Table)

Payment Selection Cycle Status

Parent record: PYCYCL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
Prompt Table: SP_PYCYCL_NONVW

2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number

3 PAY_RUN_AP_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Run Status
1=Exceptions found
2=Nothing to process
3=Process running
6=Rejected
7=Selected/Staged
8=Waiting for Certification
C=Completed
D=Reset
E=Error
K=Restarted
N=New
R=Selected
U=Created
V=Trial Register Approved
X=Printed
Y=Confirmed
Z=Positive Payment Formatted

4 PAY_THRU_DT Date(10) DATE Pay Through Date

5 PYMNT_DT Date(10) DATE Payment Date

6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

7 PAY_RUN_DT Date(10) DATE Payment Run Date

8 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

9 TIME_HH Number(2,0) SMALLINT NOT NULL Time - Hour

10 TIME_MM Number(2,0) SMALLINT NOT NULL Time - Minute

11 COMMIT_STATUS Number(2,0) SMALLINT NOT NULL Commit Status

12 DSCNT_ALRT_FLG Character(1) VARCHAR2(1) NOT NULL Discount Alert
N=No discounts lost
Y=Discounts will be lost
Default Value: N

13 NEG_BAL_FLG Character(1) VARCHAR2(1) NOT NULL Negative Balances
N=No negative balances
Y=Negative supplier balance(s)
Default Value: N

14 CNV_ERR_FLG Character(1) VARCHAR2(1) NOT NULL Conversion Error
N=No conversion errors
Y=Currency conversion error
Default Value: N

15 BAD_CURR_FLG Character(1) VARCHAR2(1) NOT NULL Wrong Currency
N=Payment currencies OK
Y=Wrong payment currency
Default Value: N

16 SAME_REF_FLG Character(1) VARCHAR2(1) NOT NULL Use Same Reference Numbers
Default Value: N

17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

18 CURTEMPINSTANCE Number(4,0) SMALLINT NOT NULL Temp Table Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle Prompt Table: SP_PYCYCL_NONVW
2	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
3	PAY_RUN_AP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Run Status 1=Exceptions found 2=Nothing to process 3=Process running 6=Rejected 7=Selected/Staged 8=Waiting for Certification C=Completed D=Reset E=Error K=Restarted N=New R=Selected U=Created V=Trial Register Approved X=Printed Y=Confirmed Z=Positive Payment Formatted
4	PAY_THRU_DT	Date(10)	DATE	Pay Through Date
5	PYMNT_DT	Date(10)	DATE	Payment Date
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	PAY_RUN_DT	Date(10)	DATE	Payment Run Date
8	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
9	TIME_HH	Number(2,0)	SMALLINT NOT NULL	Time - Hour
10	TIME_MM	Number(2,0)	SMALLINT NOT NULL	Time - Minute
11	COMMIT_STATUS	Number(2,0)	SMALLINT NOT NULL	Commit Status
12	DSCNT_ALRT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Discount Alert N=No discounts lost Y=Discounts will be lost Default Value: N
13	NEG_BAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Negative Balances N=No negative balances Y=Negative supplier balance(s) Default Value: N
14	CNV_ERR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Conversion Error N=No conversion errors Y=Currency conversion error Default Value: N
15	BAD_CURR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Wrong Currency N=Payment currencies OK Y=Wrong payment currency Default Value: N
16	SAME_REF_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use Same Reference Numbers Default Value: N
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	CURTEMPINSTANCE	Number(4,0)	SMALLINT NOT NULL	Temp Table Instance