EORC_UPDCOND

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
2 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: EORC_RCM_CMP_V

4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: EORC_CMPREC_V

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: EORC_RECFLD_V

6 FIELDUSEDAS Character(2) VARCHAR2(2) NOT NULL Field Used As
AO=As Of Date
AT=Accounting Date
BT=Bill Thru Date
CF=Cycle From Date
CT=Cycle Through Date
ED=Effective Date
ET=Exception Accounting Date
EV=Event Date
FD=From Date
FP=From Period
FY=Fiscal Year
ID=Invoice Date
IF=From Invoice Date
IT=To Invoice Date
OA=Override Accounting Date
OP=Request Date Option
PF=Process Frequency
PR=Period
RD=Request Date
ST=Bills Added On Or After
TD=To Date
TP=To Period
TT=Transaction Date
YF=From Year
YT=To Year
7 OPTIONALDATE Character(18) VARCHAR2(18) NOT NULL Optional Date Field

Prompt Table: EORC_RECFLD_V

8 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System Data

Default Value: N