RC_BP_INVL_ACTN

(SQL Table)
Index Back

Relation table for Invalid Act

This tables gives relationship between Invalid Actions and a Phase within a Business Project

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
2 EFFDT Date(10) DATE Effective Date
3 RC_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID used in Business Process tracking.

Prompt Table: RC_ACTIVITY_VW

4 RC_INVALID_ACTN_ID Character(30) VARCHAR2(30) NOT NULL Invalid Action id used for Business Projects

Prompt Table: RC_INVL_ACTN_VW

5 RC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer

Default Value: 2

6 SYSD_APPLICATION01 Character(1) VARCHAR2(1) NOT NULL PS CRM Core
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

7 SYSD_APPLICATION02 Character(1) VARCHAR2(1) NOT NULL Financial Services
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

8 SYSD_APPLICATION03 Character(1) VARCHAR2(1) NOT NULL Telecommunications
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

9 SYSD_APPLICATION04 Character(1) VARCHAR2(1) NOT NULL Government
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

10 SYSD_APPLICATION05 Character(1) VARCHAR2(1) NOT NULL Energy
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

11 SYSD_APPLICATION06 Character(1) VARCHAR2(1) NOT NULL Insurance
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

12 SYSD_APPLICATION07 Character(1) VARCHAR2(1) NOT NULL High Technology
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

13 SYSD_APPLICATION08 Character(1) VARCHAR2(1) NOT NULL HR HelpDesk
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

14 SYSD_APPLICATION09 Character(1) VARCHAR2(1) NOT NULL System Data Field for Application 9. Application 9 is used for Wealth Management.
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

15 SYSD_APPLICATION10 Character(1) VARCHAR2(1) NOT NULL Used in Application 10
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N