GPCN_A_SEC_VW(SQL View) |
Index Back |
|---|---|
sec for alertsecurity infor for alert |
| SELECT c.gpcn_bdgt_item , c.gpcn_bdgt_prd , c.gpcn_bdgt_stats , c.setid ,c.tree_name , c.tree_effdt , b.descr ,a.gpcn_bdgt_sec_d ,a.gpcn_bdgt_sec_r , a.distidtype , a.distid FROM PS_GPCN_BDGT_SEC_D a , PS_GPCN_TREE_VW b ,PS_GPCN_BDGT_DISTR c WHERE a.setid= b.setid AND b.setid=c.setid AND a.tree_name= b.tree_name AND b.tree_name= c.tree_name AND a.tree_effdt= b.effdt AND b.effdt= c.tree_effdt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPCN_BDGT_ITEM |
Character(10) | VARCHAR2(10) NOT NULL |
Budget Item
Prompt Table: GPCN_A_ITEM_DVW |
| 2 | GPCN_BDGT_PRD | Character(10) | VARCHAR2(10) NOT NULL |
Budget Period
Prompt Table: GPCN_A_PRD_DVW |
| 3 | GPCN_BDGT_STATS | Character(1) | VARCHAR2(1) NOT NULL |
Budget status
D=Distributed P=Planned Default Value: P |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 5 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: GPCN_A_T_NM_DVW |
| 6 | TREE_EFFDT | Date(10) | DATE NOT NULL |
Effective date of the Tree
Prompt Table: GPCN_A_T_ET_DVW |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | GPCN_BDGT_SEC_D | Character(1) | VARCHAR2(1) NOT NULL |
Permissions of Run Payroll Budget Distribution
Y/N Table Edit Default Value: N |
| 9 | GPCN_BDGT_SEC_R | Character(1) | VARCHAR2(1) NOT NULL |
Permissions of Run Payroll Budget Reports
Y/N Table Edit Default Value: N |
| 10 | DISTIDTYPE | Character(3) | VARCHAR2(3) NOT NULL |
Distribution ID Type
2=User ID 3=Role Name Default Value: 2 |
| 11 | DISTID | Character(30) | VARCHAR2(30) NOT NULL |
Distribution ID
Prompt Table: %EDITTABLE |