CC_RIGHTS1_VW(SQL View) |
Index Back |
|---|---|
ProCard Access Rights |
| SELECT ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PO_ACCESS_RIGHTS | Character(4) | VARCHAR2(4) NOT NULL |
Access Rights
CC01=Review Statement CC02=Access Reports CC03=Set Status to Staged CC04=Set Status to Verified CC05=Set Status to Approved CC06=Update Distrib - Restricted CC07=Update Distrib - Unrestricted CC08=Update Staged Transactions CC09=Update Verified Transactions CC10=Update Approved Transactions CC11=Update Error Transactions CC12=Unmask Card Number CC13=Add/Change/Delete Card Numbers CC14=Add/Change/Delete Proxy CC15=Add/Change/Delete Distribution CC16=Use ProCard on Requisition CC17=Use ProCard on Purchase Order CC18=Allow Override Supplier Card CC19=Reviewed Attachements |
| 2 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| 3 | CC_SEL01 | Character(1) | VARCHAR2(1) NOT NULL |
Field 01
Y/N Table Edit Default Value: N |
| 4 | CC_SEL02 | Character(1) | VARCHAR2(1) NOT NULL |
Field 02
Y/N Table Edit Default Value: N |
| 5 | CC_SEL03 | Character(1) | VARCHAR2(1) NOT NULL |
Field 03
Y/N Table Edit Default Value: N |
| 6 | CC_SEL04 | Character(1) | VARCHAR2(1) NOT NULL |
Field 04
Y/N Table Edit Default Value: N |
| 7 | CC_SEL05 | Character(1) | VARCHAR2(1) NOT NULL |
Field 05
Y/N Table Edit Default Value: N |
| 8 | CC_SEL06 | Character(1) | VARCHAR2(1) NOT NULL |
Field 06
Y/N Table Edit Default Value: N |
| 9 | CC_SEL07 | Character(1) | VARCHAR2(1) NOT NULL |
Field 07
Y/N Table Edit Default Value: N |
| 10 | CC_SEL08 | Character(1) | VARCHAR2(1) NOT NULL |
Field 08
Y/N Table Edit Default Value: N |
| 11 | CC_SEL09 | Character(1) | VARCHAR2(1) NOT NULL |
Field 09
Y/N Table Edit Default Value: N |
| 12 | CC_SEL10 | Character(1) | VARCHAR2(1) NOT NULL |
Field 10
Y/N Table Edit Default Value: N |
| 13 | CC_SEL11 | Character(1) | VARCHAR2(1) NOT NULL |
Field 11
Y/N Table Edit Default Value: N |
| 14 | CC_SEL12 | Character(1) | VARCHAR2(1) NOT NULL |
Field 12
Y/N Table Edit Default Value: N |
| 15 | CC_SEL13 | Character(1) | VARCHAR2(1) NOT NULL |
Field 13
Y/N Table Edit Default Value: N |
| 16 | CC_SEL14 | Character(1) | VARCHAR2(1) NOT NULL |
Field 14
Y/N Table Edit Default Value: N |
| 17 | CC_SEL15 | Character(1) | VARCHAR2(1) NOT NULL |
Field 15
Y/N Table Edit Default Value: N |
| 18 | CC_SEL16 | Character(1) | VARCHAR2(1) NOT NULL |
Field 16
Y/N Table Edit Default Value: N |
| 19 | CC_SEL17 | Character(1) | VARCHAR2(1) NOT NULL |
Field 17
Y/N Table Edit Default Value: N |
| 20 | CC_SEL18 | Character(1) | VARCHAR2(1) NOT NULL |
Field 18
Y/N Table Edit Default Value: N |
| 21 | CC_SEL19 | Character(1) | VARCHAR2(1) NOT NULL |
Field 19
Y/N Table Edit Default Value: N |
| 22 | CC_SEL20 | Character(1) | VARCHAR2(1) NOT NULL |
Field 20
Y/N Table Edit Default Value: N |